a simple question (hopefully)

[roach]

I have 2 tables set up with names, Im trying to query the first table, then
run a second query on another table
to find any names that werent in the first table......like this.

$query = "select name from mod_sced ;";

do stuff.....

Now..I do the other query to get any names that were not in the mod_sced
table.

$query = "select name from master_sced where name!='$name';";

problem is the second query pulls all the names that were in the first query
except for the last. I cant have duplicate names.

I cant figure this out. Can anyone gimme some tips?

Is there an easier way to do something like this? THANKS! =PP

[[deleted]]

The problem that you are running into is that $name is only holding the last entry from the first query.

What you need to do is actually reference the first table in the second query with a join. Try this for your second query instead:

SELECT master_sced.name FROM master_sced LEFT JOIN mod_sced ON master_sced.name = mod_sced.name WHERE mod_sced.name IS NULL

[roach]

Ok thats working like a charm =)

Now, how would I go one step further and check if a name occurs on a date in mod_sced?

Like this, but of course its not working =P

SELECT mod_sced.date, master_sced.name FROM master_sced LEFT JOIN mod_sced ON master_sced.name = mod_sced.name WHERE mod_sced.name IS NULL and mod_sced.date=$date;

Thanks!!

[roach]

Nvermind
I got it working =P

Thanks for the help !!

SELECT mod_sced.date, sced.name, sced.sun, sced.mon, sced.tue, sced.wed, sced.thur, sced.fri, sced.sat FROM sced
LEFT JOIN mod_sced ON sced.name = mod_sced.name and mod_sced.date='$start1'
WHERE mod_sced.name IS NULL;

wew.......