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' ; ";
> $result = mysql_query($sql,$connection ) or die(mysql_error());
>
> Calling above lines from php returns: You have an error in SQL 
> syntax near ';'  at line 1
>
> Issuing the command
>
> SELECT user FROM persons WHERE user = 'fred' AND domain = 
> 'company.net' ;
>
> in mysql give a proper result.
>
> Can anyone explain what might be causing the error???
> regards Olav
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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 = 
>'$domainName' ; ";
>$result = mysql_query($sql,$connection ) or die(mysql_error());
>
>Calling above lines from php returns: You have an error in SQL syntax 
>near ';'  at line 1
>
>Issuing the command
>
>SELECT user FROM persons WHERE user = 'fred' AND domain = 'company.net' ;
>
>in mysql give a proper result.
>
>Can anyone explain what might be causing the error???
>regards Olav
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


_
. Christian Dechery
. . Gaita-L Owner / Web Developer
. . http://www.webstyle.com.br
. . http://www.tanamesa.com.br


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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
> near ';'  at line 1

Through away the semicolon (;), that only tells the MySQL interpreter that 
the quiery should be executed.
In PHP, each call to the query function executes it.

Saludos... :-)

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-
Martín Marqués  |[EMAIL PROTECTED]
Programador, Administrador, DBA |   Centro de Telematica
   Universidad Nacional
del Litoral
-

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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 | PGP is spoken here: 0xE4D0C7C8
  Please, DO NOT carbon copy me on list replies.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-11-19 Thread Olav Drageset 

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 near ';'  at 
line 1

Issuing the command

SELECT user FROM persons WHERE user = 'fred' AND domain = 'company.net' ; 

in mysql give a proper result.

Can anyone explain what might be causing the error???
regards Olav


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]