TalkPHP - View Single Post

crazyryan · 12-07-2007, 09:24 PM

Hey

1. Will $categorycount = mysql_query("select count(*) from games where catid = '" . $row['id'] ."'"); count the total rows in the games table but only if catid is $row['id'];

2. Do I need to do a mysql_fetch_array on the query or is there any other way I can show the count result?

12-07-2007, 09:24 PM	#1 (permalink)
crazyryan The Contributor Join Date: Dec 2007 Posts: 27 Thanks: 0	MySQL Count and PHP Hey 1. Will $categorycount = mysql_query("select count(*) from games where catid = '" . $row['id'] ."'"); count the total rows in the games table but only if catid is $row['id']; 2. Do I need to do a mysql_fetch_array on the query or is there any other way I can show the count result?