redarrow Posted July 2, 2007 Share Posted July 2, 2007 my little version sorry no more idears sorry m8. <?php $picid=$_POST['picid']; $user=$_SESSION($_POST['user']); $postername=$_POST['postername']; $striptext = stripslashes(strip_tags($_POST['text'])); $finaltext = mysql_real_escape_string($striptext); $now = date("Y-m-d H:i:s"); if($_POST['submitcomment']){ $query = "INSERT INTO piccomment (picid,posterid,commentdatetime,postername,comment) VALUES ('$picid','$user','$now','$postername','$finaltext')"; query_db($query); } if(mysql_affected_rows($query)){ $getid = $_POST['picid']; header("location:pic.php?id=$getid"); exit; } ?> Quote Link to comment Share on other sites More sharing options...
Illusion Posted July 2, 2007 Share Posted July 2, 2007 I make a guess, try this query after the INSERT statement. $query2="OPTIMIZE TABLE table"; Quote Link to comment Share on other sites More sharing options...
bluebyyou Posted July 2, 2007 Author Share Posted July 2, 2007 Thank you to everyone that helped. I found the problem, and it was neither a mysql issue, or a php issue. Although, I think that my query syntax is definately much better now though, so it wasn't a total waste. The naming I had for some elements in my CSS were contradicting eachother, so the info was coming out of the DB fine, but it wasn't being shown. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.