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
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
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
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
4 matches
Mail list logo