New to Sessions

[Anon]

I'm Useing session to help protect pages on my site I pass the value of the user fine, but when I use a Selcet statement it gives me this error

Warning: Supplied argument is not a valid MySQL result resource

Heres the select statement:

$result = mysql_query("SELECT * FROM user WHERE user_name = '$user_name'");
$row = mysql_fetch_array($result);

I, trying to get the user infomation accordinglly

I never had problem with this code it's a simple code
I,m thinking it has to do with the session some how.

Please help me out

TIA
Richie TM

[Anon]

I can't see anything wrong with your code.
Use mysql_error() to output the error message. Maybe that can give you any clues to what may have gone wrong.
Also, try outputting the query so you can double-check that it looks OK.

[chinwah]

I have been using session quite often lately and i use the phplib session. And as far as i know the session rarely intefere with the select query. Unless you have use session register to register one of your variable in your query. For instance, session_register("user_name");
sometime when you start of $user_name as blank the session will keep the record of user_name as blank. So your select query will not run properly. But then the error will be different.

I think the error

Supplied argument is not a valid MySQL result resource
is regarding to your
$row = mysql_fetch_array($result) code or maybe something else

hope i could help