need help with email search...

[Will810]

I want to add a feature to a website that will look up email addresses. You put in a persons name, click a button, and it finds their email address. I would like to use flash but any info on how to do this would be great. Thanks!

[steveh]

use a mysql database using a query for for emails with the name you are looking for

[steveh]

IN html/PHP
i.e ring up every email address where name = name
if($_POST["name"]){
$sql "select email from addresses where name = $name";
$result = mysql_query($sql);
while($result = mysql_fetch_array($result)){
$emailaddress = $result['email'];
echo $emailaddress;
}

[ray326]

Where will you be "looking up" these email addresses?

[steveh]

Create a library of people you know or from something they subscribe to on your site perhaps... by creating a database with the people you know...
i.e 1st name...last name...email address. this is where the email addresses and names will be stored.

You connect to this database via mysql and php or asp or whatever as long as you can use and connect to a remote database (your using the web remember) and create a 'search for user email' page and place in a text field and a submit button wrapped in a form. Then using php, asp or whatever...create a sql query as above that will look up in the database table for an email address in a table row that has a name that matches a name you are looking for...do you get the idea

[Will810]

I was thinking of using XML or ASP for the database. Also I hope to pull the email list from our exchange server.

Steveh, Thanks for the info. I plan to try and figure out how to make that work.

[ray326]

Exchange will be more readily available if you host on IIS using ASP or .NET back end technologies. To get at it with non-MS hosting like Apache using PHP you'll need to use LDAP to get at the directory information.