View Single Post
  #6 (permalink)  
Old 11-15-2008, 08:58 AM
computergenius computergenius is offline
WebProWorld Veteran
 
Join Date: Jul 2003
Location: Spain
Posts: 343
computergenius RepRank 1
Default Re: How to extract emails from table?

It's not really as simple as it first looks.

The SQL command that you want is
SELECT emails
FROM records
WHERE username in ("peter", "william" )

You need quotes around the usernames, which you will have to add in via some code.

Exactly how you acheive this, depends on what you are using to accept input from the user.
__________________
Pete Clark
Got any spare time? Anything you need? Barter in Spain at http://BarterWithBart.com
Reply With Quote