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!