httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Taylor" <ch...@x-bb.org>
Subject Re: [users@httpd] PHP CODE DRIVING ME NUTS
Date Mon, 02 Sep 2002 22:12:29 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You need to quote the $bar with ' because if it involves a space, the
replacement with it's value will make the SQL statement invalid,
hence the SQL error.

Chris Taylor - The guy with the PS2 WebServer
Email: chris@x-bb.org - PGP: http://www.x-bb.org/chris.asc

- ----- Original Message ----- 
From: "BAO RuiXian" <bao.ruixian@atbusiness.com>
To: <users@httpd.apache.org>
Sent: Monday, September 02, 2002 10:02 PM
Subject: Re: [users@httpd] PHP CODE DRIVING ME NUTS


> Don't understand why there are two respondents telling using the
> single quotes to quote $bar, which I understand not to be resoluted
> in Perl. I would suggest simply the following:
> 
>     $SQL = "SELECT * FROM review WHERE bar_name = $bar";
> 
> 
> Best
> 
> Bao
> 
> Matthew Daubenspeck wrote:
> 
> > On Mon, Sep 02, 2002 at 03:18:16PM -0600, Grant Cooper wrote:
> > > $bar = "The Beverage";
> > > $SQL = "$SELECT * FROM review WHERE bar_name=$bar";
> > >
> > > When sql executes the statement is kills off the "The" part.
> >
> > $SQL = "SELECT * FROM review WHERE bar_name = '$bar'";
> >
> 
> --
> BAO RuiXian, PROGRAMMER, Project Consulting Team, Software Services
> Group AtBusiness Communications Corporation, Kaapeliaukio 1,
> FIN-00180 Helsinki Telephone +358-9-2311 6674, Mobile +358-50-329
> 6275, Fax +358-9-2311 6601 Web: www.atbusiness.com, Email:
> {bao.ruixian, ruixian.bao}@atbusiness.com  
> 
> 
> 
> --------------------------------------------------------------------
> - The official User-To-User support forum of the Apache HTTP Server
> Project. See <URL:http://httpd.apache.org/userslist.html> for more
> info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>    "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPXPiSiqf8lmE2RZkEQKP1gCfWecxqbv88fTpq4M2HIGyyyR72WkAnRsH
TzbmTcnp70doEWSaS9YjoVwA
=OPUY
-----END PGP SIGNATURE-----



---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message