SQL/PHP question

[ATLien]

$query = "SELECT * FROM tutorials as t, brushes as b, movies as f, templates as tp WHERE t.tutorial_active=0 && b.brush_active=0 && f.movie_active=0 && tp.template_active=0";
$result = mysql_query("$query") or die();
$sql = mysql_num_rows($result);

I have that code on my site, I was wonding, if I can use mysql_count_rows with a complex statment like that. If so, how would I echo the number of rows for the different parts of the database?

Thanks in advanced.

[Gary_King]

mysql_count_rows or mysql_num_rows?

Anyways, does it work, have you tested? Run the query in phpMyAdmin and I'm sure num_rows will return the same value shown in phpMyAdmin results page.