Topic awaiting preservation: Sessions and SQL (Page 1 of 1)

In tryigto run a sql statement
it being

SELECT * FROM users WHERE username = $_POST[usermame]

and it woudlnt work it told me a invalid sql resource was used in mysql_fetch_array and so I ran mysql_error() to find that the sql statement was treating 'username' there as the variable $username which contains the username of the person currently logged in via array I set earlier.. I dont have acsses to set Globals off which should fix the problem.

so I was wondering if anyone else had a solution
i orginaly thought icould set $username =NUll but this cuases all sorts of problems elsewhere

anwyay any help would be appreciated as always

Thanks
Trigger

Try putting the variable in quotes -

"SELECT * FROM users WHERE username = '$_POST[username]'"

I will also often set things ahead of time for ease of use later, such as -

$username = $_POST['username'];

and then use

"SELECT * FROM users WHERE username = '$username'"

[This message has been edited by DL-44 (edited 06-10-2003).]