$link = mysql_connect("localhost", "bradenonline", "|3R4D3n"); mysql_select_db('bradenonline', $link) or die("Yap Error: " . mysql_error()); if(isset($_POST["yapname"]) && isset($_POST["yaptext"])) { $yn = mysql_real_escape_string($_POST["yapname"]); $yt = mysql_real_escape_string($_POST["yaptext"]); $sql = "INSERT INTO yap (yapDate, yapName, yapText) VALUES (sysdate(), '$yn', '$yt')"; mysql_query($sql) or die("Error: " . mysql_error()); header("Location: yap.php"); return; } $sql = "SELECT DATE_FORMAT(yapDate, '%H:%i') yapDate, yapName, yapText FROM yap ORDER BY yap.yapDate DESC LIMIT 4"; $result = mysql_query($sql); $num = mysql_num_rows($result); if($num == 0) { $content = "Nothin's been yapped...yet."; } else { $content = "
| [" . mysql_result($result, $i, "yapDate") . "] | " . mysql_result($result, $i, "yapName") . ": $text |