[Resolved] counting Number of rows in a table

[Gladiator2043]

What is wrong with my code?

$query = "SELECT COUNT(*) AS rows FROM ads";
$result = mysql_fetch_row($query);
echo($result['rows']);

i am getting an error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/carbuys/public_html/place_an_ad3.php on line 9

and its not coming with the right number.....

I dont want to use mysql_num_rows();

please help.

thanks

[macca_25]

Hi,
You need to create mysql_query().

[yelvington]

More specifically

$query = "SELECT COUNT(*) AS rows FROM ads";
$result = mysql_query($query);
$result = mysql_fetch_row($result);
echo($result['rows']);

Note that you also must connect to the server before this, and select the database.

Good coding practice would be to check the returned value of the query and, if null, call mysql_error() instead of trying to fetch the row and echo the result.

[Gladiator2043]

thank you both. I appreciate the help!