Trouble with a query

[fallenangel1983]

I have a table with 8 columns named:

 

eventID    username    eventDesc    softHard    department    solved      solID        date

 

 

 

in my php page i have a button to run a query. when a username is enterd on the php page it is remembered.

 

i now want to select all from the above table where the username is equal to the username in the table

 

 

 

 

This query does not seem to work but i dont know why:

 

Select * FROM events WHERE username = '$username'

 

I know this is a fairly simple query but im new to sql and am having some trouble with finding the information on the tutorials.

 

would appreciate any help. cheers

[aztec]

Hi

 

Check that $username hold the data you think it should by printing it to the screen.

 

Regards

[fallenangel1983]

hey,

 

thanks for the reply. I checked it out and yes it holds the value. but the original php variable started with an uppercase.

 

im a fool. sorry for that but cheers anyway