How do get email from database?

[NoID]

Hello Guys,

I would like to know if its possible or not, where i can have a text box which when i enter the ID and press submit it gets the email matching that ID. and sends an email, please note that i know how to send email, i just dont know how to get data and send it can someone please give me an example on how i would do this. THank you

Have a good day

[Menster]

I'm not sure what you need: the HTML form, the SQL statement or the PHP to run it? or do you just want to pass?

[NoID]

Hello,

I have a form when everytime i fill, it gives a unique id for example

name
surename
address
postcode
[e-mail]
ID: 4

name
surename
address
postcode
[e-mail]
ID: 5

name
surename
address
postcode
[e-mail]
ID: 6

I then want a text box on say page called email.php

is like this

----------------
5 |
--------------- submit

when i click on submit, it goes to server and finds the email for record 5 and sends an email.

I hope that makes sense, thank you

have a good day

[sikka_varun]

<?php

if($_POST['submit'] == "Send Email")
{
    $sql = "Select * from tablename where id=".$_POST['id'];
    $res = mysql_query($sql);
    $data = mysql_fetch_array($res);

    $to_email = $data['email'];

    //Send mail here
    // mail($to_email,$subject,$msg);
}

?>
<form name="frmEmail" action="" method="post">
<input type="text" name="id" id="id" />
<input type="submit" name="submit" id="submit" value="Send Email" />
</form>