X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E28F6D1B527 for ; Sun, 28 Sep 2003 14:26:46 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 56981-07 for ; Sun, 28 Sep 2003 11:26:18 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id B69B2D1B4FC for ; Sun, 28 Sep 2003 11:26:09 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 71D071024D; Sun, 28 Sep 2003 10:17:27 -0400 (EDT) Received: from [192.168.1.199] (dyn-136-235.tor.dsl.tht.net [134.22.136.235]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 355D210248; Sun, 28 Sep 2003 10:17:25 -0400 (EDT) Subject: Re: HTTP_AUTH and SQL WHERE Clause From: Rod Taylor To: Rod K Cc: "Seader, Cameron" , pgsql-php@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-cTSnyfLn8GkAlzqamC0d" Message-Id: <1064759185.21931.32.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sun, 28 Sep 2003 10:26:26 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/84 X-Sequence-Number: 2361 --=-cTSnyfLn8GkAlzqamC0d Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > The former: >=20 > $sql=3D "SELECT * FROM tbl_authenticate WHERE username =3D > '{$_SERVER['HTTP_AUTH_USER']}' AND password =3D '{$_SERVER['HTTP_AUTH_PW'= ]}'"; >=20 > and the later: >=20 > $sql=3D "SELECT * FROM tbl_authenticate WHERE username =3D > '".$_SERVER['HTTP_AUTH_USER']."' AND password =3D > '".$_SERVER['HTTP_AUTH_PW']."'"; >=20 > I prefer the later since it's a bit easier to read IMO. Another alternative: $sql =3D <<