mysql query

[Anon]

hi,

does anyone have an idea why the interpreter gives me an error on following part of my code ? :

$verbindung = mysql_pconnect ("$dbhost", "$dbuser", "$dbpass")
or die ("Could not connect to db");
mysql_select_db("xxxxx", $verbindung);

$sql = "SELECT time FROM test";
$result = mysql_query($sql, $verbindung);

while ($row = mysql_fetch_array($result)){

if ($time_now - $row["time"] > 3600) {
$sql = "INSERT test (over_hour) VALUE ('true')";
$result = mysql_query($sql, $verbindung);

$sql = "DELETE FROM test WHERE over_hour='true'";
$result = mysql_query($sql, $verbindung);

}

}#while

the interpreter says that the result resource is not valid. (line where while() is)

would be glad for help

thanks in advance

ali

[knight]

you're using a while if loop which is invalid it supposed to be a while do loop

[yendor]

Ali,

You need to double check your $sql query. If it doesn't match your database structure the query will fail and your result resource $result will be invalid. Is "time" a field in the table "test", and is "test" in the database "xxxxxx". Also check for typo's in your database.

Rodney