Multiple SELECT queries; 2nd returns nothing

megachrisp

I'm trying to perform a SELECT query to two different tables, the second query using information from the first to do so. The first query goes all right and returns its stuff after using fetch_array, but the second returns nothing.

//Select posts
$result=mysql_query("SELECT * FROM posts WHERE topic='$topic'");
$select=mysql_fetch_array($result);

//Select user details
$user=$select[0];
$userselect=mysql_query("SELECT * FROM users WHERE username='$user'");
$userdetails=mysql_fetch_assoc($userselect);
echo $userdetails['username'];

There is no output from this code segment whatsoever. I know for sure that there is something for it to return, the data to be selected does exist in the table.

LordShryku

debug it

//Select posts 
$result=mysql_query("SELECT * FROM posts WHERE topic='$topic'") or die("Error on query 1: ".mysql_error());
$select=mysql_fetch_array($result);

//Select user details 
echo "<br />SELECT 0 = ".$select[0];
$user=$select[0]; 
echo "<br />user = ".$user;
$userselect=mysql_query("SELECT * FROM users WHERE username='$user'") or die("Error in query 2: ".mysql_error());
$userdetails=mysql_fetch_assoc($userselect); 
echo $userdetails['username'];

megachrisp

Returns the username all right, but absolutely nothing from the second query. No errors, no warnings, just nothing.

Complete output is this:
SELECT 0 = t3h_username
user = t3h_username