multiple count (*) from php? (last one got sent in error, this is the correct one)
| From: | Ryan A | Date: | Sun, 15 Jun 2003 03:26:31 +0000 |
| Subject: | multiple count (*) from php? (last one got sent in error, this is the correct one) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-151579@lists.php.net to get a copy of this message | ||
Hi,
I have 5 tables which keep th details for 5 packages for a company...
a company may add however many packages they wish.
When a company logs in I want to be able to tell them:
you have $numberOfPackages entered:
package1 $one
package2 $two
package3 $three
package4 $four
package5 $five
instead of running 5 "$result = "SELECT count(*) FROM mylist_slave WHERE
ptype =$inn and user='".$my_user."' and
cno='".$my_ccno."'";
is there any any way to select all 5 differient tables in one select
count(*) statement?
Thanks,
-Ryan