Adding variables from database into an email

[Tom_LR]

How do I put a variable from a database into an email form? I have a page that shows search results above and a form below that the client can fill out and email to us. I want to be able to include things like account #, etc. from the search results above in the email without the client having to type the account number into the form. Thanks

[bogu]

Using SELECT to query the DB ...

[rincewind456]

Here is a very basic example of hoe to do it:

<?php
// Do your usual mysql connect routine
$query = "SELECT accountNumber FROM accounts ";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
	$accountNumber = $row['accountNumber'];
}
?>

<form action="" method="post">
<input type="text" name="accountNumber" value="<?php print $accountNumber;?>">
<input type="submit" name="submit" value="Process">
</form>