Help getting count to show up.
| From: | Chuck Payne | Date: | Tue, 10 Sep 2002 22:25:06 +0000 |
| Subject: | Help getting count to show up. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-115899@lists.php.net to get a copy of this message | ||
Hi,
Last night I asked for help doing counts. One of the answers I got was
really great but I can't make it work. The answer I more or less show me a
great way to create a stats page,
ex. SELECT feild1, field2, COUNT(*) FROM tables GROUP BY category, format.
But my problem is I can't get count to show. I can get two of the fields.
Below is the PHP program that I am wanting to run. How can I get count to
show? Thanks.
Chuck Payne
Magi Design and Support
----------------------------------------------------------------
<?
$db = mysql_connect('localhost','user','passwd');
mysql_select_db('media',$db);
$result =mysql_query("SELECT category, format, COUNT(*) FROM library GROUP
BY category, format",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are no records to display
do {
printf("%s %s %s<br>", $myrow[category], $myrow[format], $myrow[count]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no record to display
echo 'Sorry no records were found!';
}
?>