RE: [PHP] help with mysql query / logic

2002-10-10 Thread Pablo Oliva
Please disregard, I think that I figured it out. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] help with mysql query / logic

2002-10-10 Thread 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 jo

Re: [PHP] Help with mysql query

2001-12-11 Thread Kevin Stone
Daniel, Try this. Still sort of a brute force method but just 10 query strings instead of 50 but nothing MySQL is going to balk at. Then you an print out the results stored in the $num_vals list using a similar for loop. -Kevin Stone - Original Message - From: "Daniel Alsén" <[EMAI

Re: [PHP] help with Mysql Query...

2001-09-24 Thread Steve Werby
"Christian Dechery" <[EMAIL PROTECTED]> wrote: > I have a table A and a table B... I want all occurences from A there are > not in B... > > in ANSI SQL... it's nothing more than: > > select a.id, a.name from table_a a, table_b b where a.id NOT IN (select id > from table_b) > > and that's it... but