Numbering mysql rows

[Jolten]

Hi,

I've got a very simple query I'm trying to count rows with.

$strike = mysql_query("SELECT * FROM table WHERE when = '$now'");
$per = mysql_num_rows($strike);

The problem I have is the WHERE clause. if I remove that the row numbering works fine, however, I want to only count rows where when=$now.

The $now variable is set above the query and is calling information correctly.

How can I go about counting rows where when=$now?


Thanks!

[rake]

Your code is correct. Are you sure $now is set correctly?

try
"SELECT COUNT(*) AS count FROM table WHERE when='". time()."' "

[Jolten]

oops.

I got it worked out. Thanks rake.

Using the word "when" for a database field was a bad idea. Apparently it's reserved. I changed the name of that db field, and my queries to match it, and everything works like I expect.

Thanks again.

[aussiev8]

jolten you should use rakes exmample, counting any other way is less efficient!

[Jolten]

I would but it doesn't seem to work.

[rake]

you need to mysql_fetch_array as you would any other query and then use $result['count']