Re: Newbie select statement questions 'WHERE'
| From: | Robert Cummings | Date: | Thu, 24 Apr 2008 02:18:18 +0000 |
| Subject: | Re: Newbie select statement questions 'WHERE' | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-273512@lists.php.net to get a copy of this message | ||
On Wed, 2008-04-23 at 19:07 -0700, revDAVE wrote:
> 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?
<?php
$escape = 'mysql_real_escape_string';
$query_get1 =
"SELECT "
." p_First, "
." p_id, "
." p_Last, "
." p_Lvl, "
." p_Sel "
."FROM "
." contacts "
."WHERE "
." p_First LIKE '".$escape( $_GET['p_First'] )."' "
." OR "
." p_Last LIKE '".$escape( $_GET['p_Last'] )."' ";
?>
But really... you're not doing any partial matching so don't bother with
'LIKE'. Just do the following:
<?php
$query_get1 =
"SELECT "
." p_First, "
." p_id, "
." p_Last, "
." p_Lvl, "
." p_Sel "
."FROM "
." contacts "
."WHERE "
." p_First = '".$escape( $_GET['p_First'] )."' "
." OR "
." p_Last = '".$escape( $_GET['p_Last'] )."' ";
?>
Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP