[RESOLVED] Having a little bit of a database issue.

[tomwhalen]

I'm building a website and I need to use this query... but for some reason

$qls->user_info['id']

, which is a variable, doesn't work well in this instance. I think it is because ofthe 's in the code. Any help would be appreciated.

$sql="SELECT * FROM wegoh_guestlists WHERE event_id='$pid' and user_id= '$qls->user_info['id']' ";
$result=mysql_query($sql);

[dagon]

$sql="SELECT * FROM wegoh_guestlists WHERE event_id='$pid' and user_id= '{$qls->user_info['id']}' "; 

[ixalmida]

You need to put curly braces {} around the code or PHP won't evaluate the entire expression, otherwise PHP assumes everything $qls is text.

$sql="SELECT * FROM wegoh_guestlists WHERE event_id='$pid' and user_id= '{$qls->user_info['id']}' "; 

[tomwhalen]

Aah!! Awesome! You guys are gods in my book. I was sitting here figuring I had to escape the single quotes.😃

[dagon]

you could actully leave the quotes out of the array index, but the {} is a better option.