08-19-2009, 10:48 AM
|
#3 (permalink)
|
|
The Wanderer
Join Date: Aug 2009
Posts: 15
Thanks: 11
|
Here's my code for it, but i don't know where to place that ID_ code you gave me.
PHP Code:
<?php
//Connect to database
include ('connect1.php');
$queryget = mysql_query("SELECT* FROM comments");
while ($row = mysql_fetch_assoc($queryget))
{
//get row data and store in var's
$id = $row['id'];
$name = $row['name'];
$email = $row['email'];
$message = $row['message'];
$date = $row['date'];
$time = $row['time'];
//show data to user
echo"<table><tr><td>
Posted by: <b>$name ($email) on $date</b>
</td></tr><tr>
<td>".strip_tags($message)."</td></tr></table>";
}
echo "<hr>";
if ($_POST['submit'])
{
$name = $_POST['name'];
$email = $_POST['email'];
$message = $_POST['message'];
$date = date ("m-d-Y");
$time = date ("H:i:s");
if($name&&$message)
{
$querypost = mysql_query ("INSERT INTO comments VALUES ('','$name','$email','$message','$date','$time')");
echo"Please wait..... <meta http-equiv='refresh' content='1;url=results3.php?id=$id'>";
}
else
echo "Please fill out all fields.";
}
echo "<form action='results3.php?id=$id' method='POST'><table width='100%'>
<tr><td width='5%' valign='top'>Name:</td>
<td><input type='text' name='name' maxlength='25'></td></tr>
<tr><td valign='top'>Email:</td><td><input type='text' name='name' maxlength='25'></td></tr>
<tr><td valign='top'>Message:</td><td>
<textarea cols='20' rows='2' name='message' maxlength='250'></textarea>
<p>
<input type='submit' name='submit' value='Post'>
</td>
</tr>
</table>
</form>";
?>
|
|
|
|