Error explanation?

[Anon]

Getting this error (line 17 is the while loop):

Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/test.php on line 17

from this code:

    $date = date('Y\-m\-d');

    mysql_connect('localhost', '$user', '$pass');
    mysql_select_db(classeval);
    $result = mysql_query("SELECT * FROM class where class_start <=  $date and where class_end >= $date");

    while ($row = mysql_fetch_array($result)){
            echo "$row[class_id]<br>";
    }

[crislewis]

$result is not a valid result resource so your query is not returning any records. Looking at your code it is possibily that you have not given the database name a string with quotes in

mysql_select_db(classeval);

try

mysql_select_db('classeval');

I always test $result and echo out an error if there are no records and there should be:

if (!$result = mysql_query($query)) echo "no records found. Query was: $query";

Hope this helps,

Cris

[Anon]

nevermind. the problem was the query. it says "and where" when it should just say "and".