[RESOLVED] need help with SQL string

gtzpower

Hey everyone, I have 2 tables in my DB. I am selecting records from the first table where a certain field equals a certain value. (~20 records returned). Now, I have to get all of the records in the second database who's usernames were returned from the first database.

Basically, is there a way to do a 'SELECT * FROM USER_INFO WHERE USERNAME = 'anyUserInThisArray'

I need all records in the DB to be returned if the record has a username from the array. Any ideas how to do this without looping?

devinemke

$sql = 'SELECT * FROM USER_INFO WHERE USERNAME IN(' . implode(',', $array) . ')';

solodesignz

You would need a loop... but to build the sql string...

select * from user_info where username = 'arrayval_1' or username = 'arrayval_2'

something like...

$sql = "select * from user_info where ";
foreach($array as $val){
$sql .=(isset($blah))?" or ":null;
$sql .= "username = '" . $val . "'";
$blah=true;
}

gtzpower

devinemke wrote:

$sql = 'SELECT * FROM USER_INFO WHERE USERNAME IN(' . implode(',', $array) . ')';

In the name of understanding and trying to figure out what is going on here, allow me to present this string

$sql = 'SELECT * FROM USER_INFO WHERE USERNAME IN(tim,jack,jeff,bill)';

Would this return all of the records where whe username equals either tim, jack, jeff, or bill?

gtzpower

$sql = 'SELECT * FROM USER_INFO WHERE USERNAME IN('tim','jack','jeff','bill')';

This works perfect! Thanks for introducing me to the IN command!