Re: help with mysql query / logic
| From: | Marco Tabini | Date: | Thu, 10 Oct 2002 19:34:55 +0000 |
| Subject: | Re: help with mysql query / logic | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119568@lists.php.net to get a copy of this message | ||
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.