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');

$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

Reply via email to