Cant find the problem

Anon

I am trying to create a sessions log in/out system but i keep getting an error when it runs this. I cant see what the problem is. The error i get is:

Warning: Supplied argument is not a valid MySQL-Link resource in /home/dwp/dwp-www/themix/700/sessions.php on line 89

any help would be apriciated. thanks.

//---------------------------------------------------------------------------------------
// Look for, log out, and delete all old Sessions

function CheckSession($db)
{
$expirationtime = time();
$Q04 = "SELECT *
From Sessions";
//WHERE Time < '$expirationtime'";
$R04 = Mysql_Query($Q04,$db); // this is line 89
while($Row = Mysql_Fetch_Row($R04))
{
$Session=$row[0];
$UserID=$row[2];
$UserName=$row[3];
$UserIP=$row[7];
deleteSession($db,$Session);
writeLog($db,$UserID,$UserName,$UserIP,"2");
}
return;
}

[deleted]

"Supplied argument is not a valid MySQL-Link resource "

that means you don't have any connection with the database. Always check wether the connection function actually returned TRUE.

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

Hallo dashe!

Such type of error may happen when:
1. there is no connection to the database
2. the selected database is not correct
3. spellings of table, fields, some variables you have used in your query are not correct.

Try to check for the above points....

Solomon