[RESOLVED] Syntax question

zzz

I need to run a search on a table for a record that has a zipcode. If I have a string of zipcodes: $strZipcodes = 77005,77006,77007,77008,77009; can I do something like

WHERE $zip IN $strZipcodes

Or do I need to run that string trhough some loop and create

 $zip = 77005 OR $zip = 77006 OR $zip = 77007 ...

laserlight

Yes, you can use IN, but the syntax is:

WHERE $zip IN ($strZipcodes)

If the zip codes are strings, they have to be quoted accordingly.

zzz

Great! What do you if they're strings? They are stored in a session and look just like this: 77005,77006,77007,77008,77009

zzz

Oops taking it back. I put quotes and fixed an error.

WHERE zipField IN ('".$strZipcodes."')

laserlight

Well, that works if "77005,77006,77007,77008,77009" is the string itself. But that's not likely to be what you want. More likely:

$strZipcodes = '77005,77006,77007,77008,77009';
$strZipcodes = "'" . str_replace(',', "','", $strZipcodes) . "'";

// ...

WHERE $zip IN ($strZipcodes);

zzz

Boy, am I too fast to close the tickets?.. Yes, I was wondering why I get no results. And this time can't even blame it on the lack of caffeine -- sitting with a big mug of Java...