Newbie select statement questions 'WHERE'
| From: | revDAVE | Date: | Thu, 24 Apr 2008 02:07:30 +0000 |
| Subject: | Newbie select statement questions 'WHERE' | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-273511@lists.php.net to get a copy of this message | ||
NEWBIE! I have some GET data coming from a previous search form.
How do I add the WHERE part ?
orig:
$query_get1 = "SELECT p_First, p_id, p_Last, p_Lvl, p_Sel
FROM contacts";
------W / WHERE...???
$query_get1 = "SELECT p_First, p_id, p_Last, p_Lvl, p_Sel
FROM contacts
WHERE p_First like $_GET['p_First'] or p_Last like $_GET['p_Last']";
I tried various things that make errors:
where p_First like '%$_GET['p_First ']%'";
where p_First like ".$_GET['p_First ']."";
Etc...
How can I make this work?
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]