[thelist] Re: [PHP] help with mysql query / logic

[Marco Tabini]

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.