Nested Query?

[slevytam]

Hi,

I believe this is a simple question for all you php/mysql gurus.

I have a query that I have put into $ziprow.
$ziprow = mysql_fetch_array($zipresult);

I'm looking to write a query that will select all users if their postal code is in $ziprow.

something like
select * from users where zip in $ziprow['zip'];

the problem is I believe that $ziprow['zip'] only points to one record.

So I am rather lost on how to do this,

Thanks,

--SL

[ultraslacker]

Not elegant, but works.

// get all the zips
// zips are char, so enclosed in invered commas
while ($ziprow = mysql_fetch_array($zipresult) {
	$where .= "'" . $ziprow['zip'] . "',";
}

// chop off last comma -
$ziprow = substr($where, 0, strlen($where) - 1);

$query = "SELECT * FROM users WHERE zip IN ($where)";

[slevytam]

Thanks so much!

Once I figured out that a string needed to be made, it wasn't much of a problem.

--SL