Simple Parse error please help!

[Anon]

I am having problems.. the query works just like this when I run it in mysql or access. but I get a parse error everytime when called from PHP.. below the problem code are other lines that do work, but every time I qualify the string with " " it fails.. please help

//doesn't work
$cur= odbc_exec( $cnx, "SELECT * FROM data WHERE (((data.salesrep)="Steve Rodda"))");

//does work
$cur= odbc_exec( $cnx, "SELECT * FROM data WHERE id = 5");

//does work
$cur= odbc_exec( $cnx, "SELECT * FROM data");

Please help me out.

Thanks for the help in advance.

Steve

[reagent]

"SELECT * FROM data WHERE (((data.salesrep)="Steve Rodda"))");

you need to either escape the "'s around Steve Rodda or use a single quote(') instead

i.e. 'Steve Rodda'

[Anon]

That worked man thank you very much.

If I may... why does that matter?

Steve Rodda

[steved]

It matters because php parses from the opening quote (before the SELECT) to what it thinks is the ending quote (after the equal sign) and gets:

"SELECT * FROM data WHERE (((data.salesrep)="

It then doesn't know what to do with the leftovers:

Steve Rodda"))");