SQL syntax issue

netfrugal

I keep getting this error for updating a table with another table:

You have an error in your SQL syntax near 'SELECT givenname FROM ldap_ad WHERE samaccountname = Requestor), sn = ' at line 2

Here is the sql query:

mysql_query(

"UPDATE results SET
givenname = (SELECT givenname FROM ldap_ad WHERE samaccountname = Requestor),
sn = (SELECT sn FROM ldap_ad WHERE samaccountname = Requestor)
"
)

or die(mysql_error());  [/COLOR]

The update query works on Windows a OS, but I get this error on a Linux OS.

-any ideas why?

thanks!

bretticus

"UPDATE results SET
givenname = (SELECT givenname FROM ldap_ad WHERE samaccountname = Requestor),
sn = (SELECT sn FROM ldap_ad WHERE samaccountname = Requestor)
"

shouldn't Requestor be wrapped in quotes?

"UPDATE results SET
givenname = (SELECT givenname FROM ldap_ad WHERE samaccountname = 'Requestor'),
sn = (SELECT sn FROM ldap_ad WHERE samaccountname = 'Requestor')
"

netfrugal

Funny you should ask that. I did try wrapping Requestor inside quotes, but still got the error.

bretticus

Ok then, what version of MySQL are you running (does it support subqueries?) Please post your table schema.

Thanks

NogDog

Yeah, it could be the subquery. They're not supported until MySQL 4.1, and I ran into that problem when working on a script for a site that was on a shared host running 4.0.

netfrugal

Well, my version of mysql is 3.23.58
So, this is probably the reason.

I will upgrade and let you all know what happens.