On Tue, 7 Sep 2004 13:16:20 -0400 (EDT), Pete Holsberg <[EMAIL PROTECTED]> wrote:
> With a Unix shell programming background, I'm puzzled by
> the use of 'tics' (single quotes, apostrophes' around
> %$search_string%. I would have though that they would have
> removed the special meaning of the $.
From: "Pete Holsberg" <[EMAIL PROTECTED]>
$sql = "SELECT * FROM $table ";
$sql .= "WHERE `LastName` LIKE` '%$search_string%' ";
$sql .= "OR `FirstName` LIKE '%$search_string%' ";
$sql .= "OR `Spouse` LIKE '%$search_string%' ";
$sql .= "OR `Street` LIKE '%$search_string%' ";
$sql .= "OR `Email` LIKE
On Tue, 2004-09-07 at 12:16, Pete Holsberg wrote:
> Also, should I have back tics around a column name
> EVERYWHERE it's used in a SELECT (in this case, following
> ORDER)?
Only if you plan to use keywords as field names, otherwise it's
pointless.
--
Greg Donald
--
PHP Database Mailing List (
