[SOLVED] Database query help

[herghost]

Hi All,

 

Should be a simple one I hope, think I am just missing some logic somewhere.

 

I have this:

 

$query="SELECT user_id FROM forum_question WHERE username =" . $_SESSION['username'] ."";
$result=mysql_query($query) or die ("oh dear   " .mysql_error()) ;
while($rows=mysql_fetch_array($result))
{
$_SESSION['user_id'] = $rows['user_id'];
}

 

Which is just meant to set the session from a the users id in the database.

 

Now I am logged in as user 'admin', However I am getting the error 'oh dear Unknown column 'admin' in 'where clause'

 

However when I double checked my database, admin is definitly listed on a row and has posted a question.

 

What am I missing?

 

 

[Philip]

$query="SELECT user_id FROM forum_question WHERE username =" . $_SESSION['username'] ."";

should be

$query="SELECT user_id FROM forum_question WHERE username = '" . $_SESSION['username'] ."'";

Notice the single quotes.

[herghost]

lovely, thanks!