I am getting the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
There's not even a '"' on line 1 or near it... Doesn't make sense at all.
<?php
session_start();
if ($_SESSION['uid']) {
if (isset($_POST['reply_submit'])) {
include_once("connect.php");
$creator = $_SESSION['uid'];
$cid = $_POST['cid'];
$tid = $_POST['tid'];
$reply_content = $_POST['reply_content'];
$sql = "INSERT INTO posts (category_id, topic_id, post_creator, post_content, post_date) VALUES ('".$cid."', '".$tid."', '".$creator."', '".$reply_content."', 'now())'";
$res = mysql_query($sql) or die(mysql_error());
$sql2 = "UPDATE categories SET last_post_date=now(), last_user_posted'".$creator."' WHERE id='".$cid."' LIMIT 1";
$res2 = mysql_query($sql2) or die(mysql_error());
$sql3 = "UPDATE topics SET topic_reply_date=now(), topic_last_user'".$creator."' WHERE id='".$tid."' LIMIT 1";
$res3 = mysql_query($sql3) or die(mysql_error());
// Email Sending
if (($res) && ($res2) && ($res3)) {
echo "<p>Success</p>";
} else {
echo "<p>Error</p>";
}
} else {
exit();
}
} else {
exit();
}
?>
Here's where the form is...
<?php
session_start();
error_reporting(E_ALL ^ E_DEPRECATED);
if ((!isset($_SESSION['uid'])) || ($_GET['cid'] == " ")) {
header("Location: index.php");
exit();
}
$cid = $_GET['cid'];
$tid = $_GET['tid'];
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="author" value="Joel Evans">
<title>MCArcade - Forums: Reply to Thread</title>
<link rel="stylesheet" type="text/css" href="css/main.css">
<link rel="stylesheet" type="text/css" href="css/mobile.css">
<link rel="stylesheet" type="text/css" href="css/font-icon.css">
<script src="js/jquery.js"></script>
<script>
$(document).ready(function(){
$('li').hover(function(){
$(this).find('ul>li').stop().slideToggle("fast", function(){
});
});
});
</script>
</head>
<body>
<div class="forum-header">
<div class="container">
<h2>MCArcade</h2>
</div>
</div>
<ul class="forum-navbar">
<div class="container">
<li><a href="http://www.mcarcade.com">Home</a></li>
<li><a href="http://www.mcarcade.com/community/">Community</a>
<ul>
<li><a href="http://www.mcarcade.com/forums/">Forums</a></li>
<li><a href="http://www.mcarcade.com/servers/">Servers</a></li>
</ul>
</li>
<li><a href="http://www.mcarcade.com/purchase/">Purchase</a></li>
<li><a href="http://www.mcarcade.com/support/">Support</a></li>
<?php
if (!isset($_SESSION['uid'])) {
echo "<li><a href='http://www.mcarcade.com/login.php'>Login</a></li>";
} else {
echo "<li>Welcome, ".$_SESSION['username']."!</li><li><a href='logout_parse.php'>Logout</a>";
}
?>
</div>
</ul>
<div class="container">
<form action="post_reply_parse.php" method="post">
<p>Reply Content</p>
<textarea name="reply_content" rows="5" cols="75"></textarea>
<br /><br />
<input type="hidden" name="cid" value="<?php echo $cid; ?>" />
<input type="hidden" name="tid" value="<?php echo $tid; ?>" />
<input type="submit" name="reply_submit" value="Post Reply" />
</form>
</div>
</body>
</html>
