multiple count (*) from php? (last one got sent in error, this is the correct one)

From: 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

« previous php.general (#151579) next »