maybe this ..
PHP Code:
<?php
include 'config.php';
include 'opendb.php';
// if the form has not been posted, print the form
if(!$_POST){
$query = "SELECT id, name, email, message FROM guestbook WHERE id = '".$searchid."'";
$result = mysql_query($query);
// since we're only getting 1 row, we can use 'if' instead of 'while'
if($row = mysql_fetch_assoc($result))
{
$id =$row['id'];
$name = $row['name'];
$email = $row['email'];
$message = $row['message'];
echo "<h2>Send an e-mail to ".$name."</h2>
<form name=\"form1\" method=\"POST\" action=\"contactmesent_old.php\">
<input type=\"hidden\" name=\"searchid\" value=\"".$searchid."\">
Your Email: <input type=\"text\" name=\"from\"><br>
Subject: <input type=\"text\" name=\"subject\"><br>
Message: <textarea name=\"message\"></textarea><input type=\"submit\" value=\"send\">
</form>";
}else{
echo "error: id not found";
}
}else{
// send email and say thank you
$result = mysql_query("SELECT id, name, email, message FROM guestbook WHERE id = '".$_POST['searchid']."'");
if($row = mysql_fetch_assoc($result)){
mail($row['email'], $_POST['subject'], $_POST['message'], "From: ".$_POST['from']);
echo "Thank You, Your email as been sent";
}else{
echo "Error: Invlid User ID";
}
}
mysql_close();
?>