Newbie select statement questions 'WHERE'
[email protected] (revDAVE)
| Newsgroups | php.general |
|---|---|
| Message-ID | <C4353972.2798B%[email protected]> |
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]