fill data dynamically from a database to a php file

[bakz]

Halo I am new here.

I need help on how to fill in data dynamically from a database to a php file---

Assuming I have a mySQL database named " contact "
There are two columns and three rows.
The columns are named id and email.
In the rows I have under id, 1 2 3
Under email I have 3 email addresses something like this:

---

id | email

---

1 | [e-mail]
2 | [e-mail]
3 | [e-mail]

Then I have a php feedback form processor and in one of the lines I have:

$receiveremail = "" ; //fill in receiver email address

Normally the receiver email address will be filled in between the ""

But I want to have it dynamically filled in from the email address from different ids in the database above.

Can anyone help me on how to write the code for it?

Help will be much appreciated.

Thanks

Bakz

[leatherback]

Assuming in your feedbackform you specify the userid to which the email should go:

$id = $_POST['id']; // Do some maliceous code trapping, if you have a script

$getid_query = "select * from contact where id=$id"; 

$result = mysql_query($getid_query) or die(mysql_error());

while($row = mysql_fetch_array($result))
  {
  $receiveremail = $row['email'];
  }

ps: untested or anything. But should work

[bakz]

Hi leatherback

Thanx for the code. I will give it a try soon.

Your help is much apprecieted.

Bakz