Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
10-12-2004, 09:28 PM #1
- Join Date
- Jan 2004
- Thanked 0 Times in 0 Posts
Showing data from a column depending on another (removed from PHP and sent to MYSQL)
I have a web page where users enter their email address to be added into a table (for a future newsletter) however, if they become a member (which is another table) i don't need the email anymore. Now to make it more simple, I don't need to do an UPDATE query. What i'm going to do is create another page that'll show the list of emails from the newsletter table, except the duplicates from the members table.
i guess something like this
SELECT newsletter,member WHERE newsletter.email != member.email
Does it make sense?
i'm sorry, this is a MYSQL question...i'm gonna post it there...sorry
Last edited by grudz; 10-12-2004 at 09:56 PM.