Sebastian wrote:
i have two scripts included into one page, one of them i have been running for a long time .. i recently made another script and when i include it into the same page the other script returns this error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/public_html/file.php on line 59
This is part of the sql query that conflicts with the other, any ideas? it only happens when this snippet is included in the same page that the other is included into.
function load() {
mysql_connect($hostname,$username,$password) or die ( "Could not connet to MySQL" ); mysql_select_db($database) or die ( "Could not connect to database" );
// Delete $sql = "DELETE FROM $table WHERE time < " . (time()-$duration); $result = @mysql_query($sql) or die ("Error:" . mysql_error() );
// Insert $sql = "INSERT INTO $table (time) VALUES (" . time() . ") ";
$result = @mysql_query($sql) or die ("Error:" . mysql_error() ); // Get count
$sql = "SELECT time FROM $table";
$result = @mysql_query($sql) or die ("Error:" . mysql_error() );
return mysql_num_rows ($result);
}
TIA.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
