Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    Regular Coder
    Join Date
    Jan 2004
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Showing data from a column depending on another (removed from PHP and sent to MYSQL)

    Hi,

    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?

    Thank you

    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.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •