Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread Greg Donald
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

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread John Holmes
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

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread randy
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 $.