Sessions with MySQL

[Anon]

I'm running a login system and securing pages with a session_start(); I registered the $user_name in the session but when I try to run a select statement to access the database

and user the mysql_fetch_array() ie

$row = mysql_fetch_array($result);

I Receive a error like this

Warning: Supplied argument is not a valid MySQL result resource.

thus I can't access the database

ps. I user the user_name in the where clause

any Help is appreciated
TIA
Richie TM

[Anon]

Where is all of the code. We need to see more code if you want some help. It sounds like your query isn't returning anything.

Could be improper database connection or bad sql statement.

I suggest placing some debug statements in your code. Echo out the sql and some variable values. Make sure they are actually what you think they are.

Also make sure that you don't use the @ symbol for your mysql calls. That will supress errors which is something you don't want if you are debugging.

Hope this helps.