Search number entries on a mysql database with COUNT

Question

I have a mysql database which allocate:

iid, name, description, url, namecategory, idcategory, nametopic, idtopic

How can i know the number of entries that has categoryid=1 and topicid=1?

I've tried

$result = mysql_query("SELECT COUNT(id) 
                         FROM videos 
                        WHERE idcategory = 1 
                          AND idtopic = 1")

...but it hasn't worked!

Answer 1

you have stated that column names are idcategory and idtopic, and in the query you use categoryid and topicid.

Make those match and then try it out.

Answer 2

Run this code and paste the result:

$result = mysql_query("SELECT COUNT(id) AS cnt FROM videos WHERE idcategory=1 AND idtopic=1");
$row = mysql_fetch_assoc ($result);
var_dump ($row);