Session check is not working

[SirChick]

I have a session which bounce's out the user if the session doesn't contain their UserID.

I aint even changed the code in any way the only substantial change i have done is copy n pasted the script to a different pc and now it won't work at this pc. But it still does on the other computer even though they are 100% the same.

 

This is the session check:

$GetUserID = mysql_query("SELECT * FROM userregistration
                    WHERE UserID='{$_SESSION['Current_User']}'");

                  
// Fetch the row from the database
if (!($row = mysql_fetch_assoc($GetUserID))) {
    echo "User not found!";
    exit;
echo mysql_error();
}

 

The result gives:

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\include.php on line 41

User not found!

[marcus]

Is the variable defined, or better yet, have a value?

[SirChick]

$_SESSION['Current_User'] when echo'd = 1 which is correct

[marcus]

 or die(mysql_error());

 

error reporting is good

[SirChick]

Doesn't give any error for that.

 

I echo'd the query which gives:

Resource id #5

 

If that means anything?

[darkfreaks]

 

 

if (!isset($row = mysql_fetch_assoc($GetUserID))) {
    echo "User not found!";
    exit;
echo mysql_error();

[marcus]

-tries to decipher darkfreaks's post-

[SirChick]

 

 

if (!isset($row = mysql_fetch_assoc($GetUserID))) {
    echo "User not found!";
    exit;
echo mysql_error();

 

=/ whats this do exactly ? never seen something like that before.

 

[marcus]

Use mysql_num_rows

[darkfreaks]

 

 

if (!isset($row = mysql_fetch_assoc($GetUserID))) {
    echo "User not found!";
    exit;
echo mysql_error();

 

=/ whats this do exactly ? never seen something like that before.

 

 

 

if the row isnt set it errors else it displays the userid