Query wont work...

[SirChick]

I have a query which is finding the user's row as its not producing any errors yet when i echo the variable it comes out as "0" when in the database the data is "1". I've no idea where its getting "0" from, what did i do wrong?

 

$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();
}


$JailID = $row['JailID'];
Echo $JailID;


If ($JailID == 1 ){
header("Location: Jail1.php");
}

[freakstyle]

hey there,

2 suggestions for ya,

 

1. take the query you are sending and query the db directly, using a gui tool or phpmyadmin or command line. see what happens.

2. var dump the $JailID to see what type it is. maybe its coming in as bool?

 

i did a quick test off your data and was able to get something back from my db.

ref: http://us.php.net/mysql_fetch_assoc

 

good luck.

 

[SirChick]

Ok thankyou