[RESOLVED] count number of entries in a table

[anarchoi]

hi,

i have a table in my database called "THREAD" and where a row is called FORUMID

i'd like to show how many entries in this table have FORUMID set to 47

could anyone please hook me up with a code that could do that?

thanks a lot !

[Kudose]

$sql = mysql_query("SELECT count(FORUMID) FROM THREAD WHERE FORUMID='47'");
echo mysql_result($sql, 0);

[anarchoi]

I get this error 🙁

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /index.php(64) : eval()'d code(182) : eval()'d code(348) : eval()'d code on line 31

[laserlight]

What is the code that you tried?

[anarchoi]

sorry, my bad, i just realized tables name are case-sensitive :/

[bradgrafelman]

So... does that you've resolved your issue? If so, don't forget to mark this thread resolved.