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!';
}
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
