ok i've just been making a small guestbook script thing and i've done a basic template for the front page and inserted data via mysql. It works: http://www.tcwonline.org/~dale/guestbook/
Now the view link wont work though. Now how would i do this:
<?php
$id = trim($_REQUEST['id']); // REQUEST so you can still grab the id from a POST form
mysql_pconnect("localhost","username","password") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
$result = mysql_query("select * from guestbook where id='$id'") or die(mysql_error()); // added: where id='$id'
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$title=$r["title"];
$msg=$r["msg"];
$author=$r["author"];
$email=$r["email"];
$date=$r["date"];
echo "WHATEVER I WANNA ECHO";
}
?>