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 "
."WHERE "
." producer like '%apple%' "
."UNION SELECT "
." designation, "
." (designation like '%apple%') AS designationMatched "
."WHERE "
." 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
