Re: [PHP] query works in mysql, but not from php

2001-11-19 Thread Steve Cayford
You don't need to put in the final semi-colon when running a query from php. Take that out and you should be fine. -Steve On Monday, November 19, 2001, at 04:58 PM, Olav Drageset wrote: > Hi > > $sql = "SELECT user FROM persons WHERE user = '$firstName' and domain = > '$domainName' ; "; > $r

Re: [PHP] query works in mysql, but not from php

2001-11-19 Thread Christian Dechery
remove the ";" at the end... mysql_query() doesn't need it... since it only executes on atomic command, the ";" is useless.. that's what's causing the error... At 22:58 19/11/01 +, Olav Drageset wrote: >Hi > >$sql = "SELECT user FROM persons WHERE user = '$firstName' and domain = >'$domai

Re: [PHP] query works in mysql, but not from php

2001-11-19 Thread Martín Marqués
On Lun 19 Nov 2001 19:58, Olav Drageset wrote: > Hi > > $sql = "SELECT user FROM persons WHERE user = '$firstName' and domain = > '$domainName' ; "; $result = mysql_query($sql,$connection ) or > die(mysql_error()); > > Calling above lines from php returns: You have an error in SQL syntax > nea

Re: [PHP] query works in mysql, but not from php

2001-11-19 Thread Brian Clark
Hi Olav, @ 5:58:14 PM on 11/19/2001, Olav Drageset wrote: OD> Hi OD> $sql = "SELECT user FROM persons WHERE user = '$firstName' and domain = '$domainName' ; "; Remove the semi-colon: $sql = "SELECT user FROM persons WHERE user = '$firstName' and domain = '$domainName'"; -- -Brian Clark | P