Newbie select statement questions 'WHERE'
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]
|