Ok i got a table 30dayatt
I got another member_list
What i need to do is compare member_list to 30dayatt and give the names that dont match and where active=1.
So if i got a name like mark in member_list but not in 30dayatt it will show my name.
look up 'joins' in the mysql (or what ever db you are using) manual
im using mysql. Ive looked it up and just cant get it to work right.
This is what i got so far.
SELECT m.name FROM member_list AS m RIGHT JOIN 30dayatt ON m.name NOT LIKE 30dayatt.name WHERE active='1' GROUP BY m.name
