Hey all. I have this guestbook script:
<?php
// CONNECT TO DATABASE
// put your details here
define ('HOST','freeprohost.com');
define ('USER', 'vsffc_database' );
define ('PASS', 'fotball' );
define ('DB', 'vsffc_database');
$connection=mysql_connect(HOST, USER, PASS);
if ($connection){
mysql_select_db(DB);
}else{
echo ('Could Not Connect to Database');
exit;
}
// if name variable exists add it to database THEN display all entries.
if ($HTTP_POST_VARS['txtName']) {
// add to database
$name = stripslashes($HTTP_POST_VARS['txtName']);
$message = stripslashes($HTTP_POST_VARS['txtMessage']);
$query = "INSERT INTO guests SET message='$message', name='$name', date=NOW()";
$result = mysql_query($query);
}
?>
<?
// DISPLAY CODE GOES HERE
$query = "SELECT id, name, message, DATE_FORMAT(date, '%d.%m.%y kl. %H:%i') as newdate FROM guests ORDER BY id DESC";
$result = mysql_query($query);
while ($row=mysql_fetch_object($result)) {
$date=date($row['date'], '%d.%m.%y kl. %H:%i');
echo '<p><br /><b>Skrevet av '.$row->name.' den '.$row->newdate.'</b><br>'.$row->message.'</p>';
}
?>
</td>
<td width="1px" class="contentborder"> </td>
<td class="bpage_contentfont" valign="top" width="40%"><p><b>Skriv i gjesteboken</b></p>
<form name="guest" method="post" action="guestbook.php">
<p><label for="txtName"><b>Navn</b></label><br />
<input name="txtName" type="text" title="Skriv inn ditt navn" size="30" maxlength="40" />
</p>
<p><label for="txtMessage"><b>Beskjed</b></label><br />
<textarea name="txtMessage" cols="25" rows="5" title="Skriv inn din beskjed"></textarea>
</p>
<p><label title="Legg inn beskjeden">
<input name="submit" type="submit" value="Legg inn" /></label></p>
</form>
</td>
Could anyone help me getting some sort of delete function? Someone told me I could delete from myPhpAdmin, how do I do that? And how could I maybe add some sort of LIMIT option, and just display number under the script? Like 1,2,3,…
Thanks alot for any replies!
Fatnslow