"localhost", "user" => "user", "pass" => "password", "db" => "db" ); $rows = 5; // Number of messages on each page ?>\n";?> ".$t.""; } elseif($a == 2) { $s = "".$t.""; } } return $s; } $link = MySQL_connect($MySQL["host"], $MySQL["user"], $MySQL["pass"]) or die("#564654"); MySQL_select_db($MySQL["db"]) or die("#222"); if(isset($_POST['action']) && $_POST['action'] == "add") { $query = "INSERT INTO guestbook (name, nick, email, website, message, added) VALUES ("; $query .= "'".$_POST['name']."',"; $query .= "'".$_POST['nick']."',"; $query .= "'".$_POST['email']."',"; $query .= "'".$_POST['website']."',"; $query .= "'".$_POST['message']."',"; $query .= "now());"; MySQL_Query($query); echo " Your entry has been added..
\n"; echo " Go Back"; } else { $query = "SELECT count(id) FROM guestbook"; $result = MySQL_Query($query) or die("sadsd"); $field = MySQL_fetch_array($result); $totalrecords = $field[0]; $totalpages = $totalrecords / $rows; if(intval($totalpages) < $totalpages) { $totalpages++; } $totalpages = intval($totalpages); if(!isset($_GET['page'])) { $page = 1; } else { $page = $_GET['page']; } $displayrows = $page * $rows - $rows; echo " \n"; $query = "SELECT * FROM guestbook ORDER BY added DESC LIMIT ".$displayrows.", ".$rows.";"; $result = MySQL_query($query) or die("asdsda"); while($field = MySQL_fetch_array($result)) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

".$field["name"]." - ".$field["nick"]."

".$field["message"]."

Email:".na($field["email"],1)." - WebSite: ".na($field["website"],2)."

\n"; if($page > 1) { echo " << Previous |"; } for($i = 1;$i <= $totalpages;$i++) { if($i == $page) { echo " ".$i."|\n"; } else { echo " ".$i."|\n"; } } if($page < $totalpages) { echo " Next >>"; } echo "

---

\n"; echo "

\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "

Name:
Nick:
E-Mail:
Website:
Message:

\n"; echo "

\n"; } MySQL_Close($link); ?>

---

Created by