On Tue, Aug 13, 2002 at 12:13:35PM -0700, Keith Posehn wrote: > > I have the code together now to put it all the zip codes into and array--but > now I need to add those zip codes to a sql statement for the WHERE clause. > > SELECT * FROM [table] > WHERE zip="[all the darn zips listed here]"
$query = "... WHERE zip IN ('" . implode("','", $ZipArray) . "')"; --Dan -- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php