help with mysql query / logic
| From: | Pablo Oliva | Date: | Thu, 10 Oct 2002 19:40:58 +0000 |
| Subject: | help with mysql query / logic | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-119567@lists.php.net to get a copy of this message | ||
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.