Simple question.

[langer]

<?php
$today = date("m.d.y");
?>

<?

$result = mysql_query( "SELECT * from news WHERE date = '$today'" );
$num_rows = mysql_num_rows( $result );

print "<p>$num_rows are in the table.</p>";

?>

That isn't working. I want to select data from news from today. When the data is added, the date is put into a table.

The error I get is: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/******/news.php on line 40

How do I get around this?

[Stressed]

Do this.

$result = mysql_query( "SELECT * from news WHERE date = '$today'" ) or die(mysql_error());

See what the message is that its bombing on. I bet you have a table name, or col name wrong or something.

[langer]

Ahh, thanks.

I won't tell you what my error was - I feel stupid now. lmao

[Stressed]

Originally posted by langer
Ahh, thanks.

I won't tell you what my error was - I feel stupid now. lmao

We've all done it, yesterday I chased my tail for an hour because of a missing = sign. 🙂