On Fri, 2008-04-11 at 23:42 -0400, Robert Cummings wrote:
> On Fri, 2008-04-11 at 20:25 -0700, Rob Gould wrote:
> > I'm trying to figure out a way that SQL can pass a flag to PHP to say which column "matched" during a query.
> >
> > Let's say for instance that I want to search for the word "apple" in both column "producer", and column "designation". I was hoping I could do something like this:
> >
> >
> > Select producer, flag=1 from wine
> > where producer like '%apple%'
> > UNION
> > Select designation, flag=2 from wine
> > where designation like '%apple%'
>
> <?php
>
> $query =
> "SELECT "
> ." producer, "
> ." (producer like '%apple%') AS producerMatched "
."FROM "
." wine "
> ."WHERE "
> ." producer like '%apple%' "
> ."UNION SELECT "
> ." designation, "
> ." (designation like '%apple%') AS designationMatched "
."FROM "
." wine "
> ."WHERE "
> ." designation like '%apple%' ";
Sorry, forgot the FROM clause. BTW, you shouldn't use a union, this can
be cleaned up to the following query:
<?php
$query =
"SELECT "
." producer, "
." (producer like '%apple%') AS producerMatched, "
." designation, "
." (designation like '%apple%') AS designationMatched "
."FROM "
." wine "
."WHERE "
." producer like '%apple%' "
." OR "
." designation like '%apple%' ";
?>
Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
