I created an array using the following:
$in_list = "'".join("','",$cen_chiefs)."'"; //$cen_chiefs is an array
$query_cen_chiefs = "SELECT * FROM central WHERE CONCAT(strName,'
',strCity,' ',strState) IN({$in_list})";
How would I go about adding an AND clause to the above query to return all
rows where strName column values are in $in_list array
I acutally did the above w/ "SELECT * FROM central WHERE CONCAT(strName,'
',strCity,' ',strState)
IN({$in_list}) AND (strName) IN({$in_list}) ORDER BY conName"; // This
return zero rows.
I think I Should I be using strName as a pattern, because strName would be a
partial value of $in_list array values?
Something like: REGEXP '^.....$'
"SELECT * FROM central WHERE CONCAT(strName,' ',strCity,' ',strState)
IN({$in_list}) AND (REGEXP '^strName$') IN({$in_list}) ORDER BY conName";
//This query doesn't work by the way. This is where I'm stuck.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
