Can you perhaps post the structure of your tables? That would make it easier to help (at least for me)
On Thu, 2002-10-10 at 15:40, Pablo Oliva wrote: > I have 2 tables, one with job ad information, and a second one with the > locations that this ad applies to. > > When a person queries the job ad table with their criteria, I would also > have to query the location table to see if the location that they chose > applies to this ad. I am not sure how to construct the sql query > though, or if there is a better way to set this up. > > Any suggestions will be appreciated. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php