[SOLVED] echo wont work on second query

[SirChick]

I have two queries searching for UserID on two tables... but it wont echo my second query.. the first one works how ever even though they are structured the same.

 

This is what i have:

 

// Get the user's info from the database by putting
// the user id stored in the session into the WHERE clause
$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();
}

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

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

$UserID = $row["UserID"];
$HouseType = $houserow["HouseID"];

Echo $UserID
Echo $HouseType

 

The result is:

 

UserID : 23

House :

 

Anyone know why?

[MadTechie]

$GetHouseInfo = mysql_query("SELECT * FROM houses WHERE UserID='{$_SESSION['Current_User']}'") or die(mysql_error());

[SirChick]

Ok just tried it and still got :

 

UserID : 23

House :

 

 

[pranav_kavi]

try printing out the query before executing it.

Is the column name right

$HouseType = $houserow["HouseID"];

[SirChick]

HouseID  int(11)

 

Table name : houses

 

i just copied and pasted. they are deffinatly correctly.

 

i tried to print it and it came out blank

[MadTechie]

do

print_r($houserow);

 

below the echo

[SirChick]

11Array ( [HouseID] => 1 [CityID] => 1 [HouseType] => Cottage [userID] => 1 )

 

 

print ^

[pranav_kavi]

pls post how the problem was solved.it wud help others who wud come across similar issues.

[MadTechie]

the problem is possible the down to the error not reported

 

Echo $UserID
Echo $HouseType

 

notice the lack of ;