[RESOLVED] Simple Query Troubles...

[middleman666]

hey people,

I know this is something really simple, but I can't for the life of me figure it out.

I have this query I want to run:

$query = "select displayname from Profile where username = $theusername limit 1";

it is not reading the $theusername variable correctly or at all.

I can do:

$query = "select displayname from Profile where username = 'joeblogs' limit 1";

and that works fine, but I need to be able to do it the top way.

Can anyone point of the mistakes I'm making?

Thanks.

EDIT: figured it out... had to use \"$theusername \" instead!

[dougal85]

btw... i know you fixed it, but an easy solution is;

$query = "select displayname from Profile where username = '$theusername' limit 1";

Dougal

[middleman666]

So it is! I swear I tried that one with no luck before... must of had me eyes closed. Thanks!