Count Rows in phpMyAdmin

[matvespa]

Hi. I having trouble with counting rows in phpmyadmin.

 

It works fine this way:

$result_rows = mysql_query("SELECT * FROM events");

 

But when i modify the code to this it doesnt work at all.

$result_rows = mysql_query("SELECT * FROM events WHERE category = 'adults' ORDER BY 'date'");

 

Any idea what is wrong?

[cunoodle2]

if you want to know the number of results you have to use "count" like this..

$result_rows = mysql_query("SELECT count(*) FROM events WHERE category = 'adults' ORDER BY 'date'");

 

If that is not what you are looking for then you will have to give me more info.  Your post is vague as you don't tell us if there are any error messages or exactly what the issue is.

[matvespa]

$result_rows = mysql_query("SELECT count(*) FROM events WHERE category = 'adults' ORDER BY 'date'");
while($row = mysql_fetch_array($result_rows)){
$id = $row["id"];
echo $result_rows;

 

I got a Resource id #5 error.

[voip03]

$result_rows = mysql_query("SELECT * FROM events WHERE category = 'adults' ORDER BY 'date'");

Remove single quotation mark

$result_rows = mysql_query("SELECT * FROM events WHERE category = adults ORDER BY date");

You can use  mysql_num_rows() to count number of rows.