mysql not sending
Posted: Tue Oct 11, 2005 12:41 am
This code isn't sending the data to the table, but no error shows and it still echo's.
Did I type something in wrong? Thanks!!!
Code: Select all
if($cmd == "submit") {
$title = $_POST["title"];
$system = $_POST["system"];
$subsystem = $_POST["subsystem"];
$username = $_POST["username"];
$image = $_POST["image"];
$ext = $_POST["ext"];
$link = $_POST["link"];
$rate1 = $_POST["rate1"];
$rate2 = $_POST["rate2"];
$rate3 = $_POST["rate3"];
$rate4 = $_POST["rate4"];
$rating1 = $_POST["rating1"];
$rating2 = $_POST["rating2"];
$rating3 = $_POST["rating3"];
$rating4 = $_POST["rating4"];
$comment1 = $_POST["comment1"];
$comment2 = $_POST["comment2"];
$comment3 = $_POST["comment3"];
$comment4 = $_POST["comment4"];
$finalcomment = $_POST["finalcomment"];
$submittodatabase=MYSQL_QUERY("INSERT INTO review (id,title,subsystem,username,image,ext,link,rate1,rate2,rate3,rate4,rating1,rating2,rating3,rating4,comment1,comment2,comment3,comment4,finalcomment)".
"VALUES ('NULL', '$title', '$system', '$subsystem', '$username', '$image', '$ext', '$link', '$rate1', '$rate2', '$rate3', '$rate4', '$rating1', '$rating2', '$rating3', '$rating4', '$comment1', '$comment2', '$comment3', '$comment4', '$finalcomment')");
echo "Thank you $c_name for submitting a review. To view it, <a href=\"index.php?id=reviews&cmd=view&title=$title&subsystem=$subsystem\">Click Here</a>.";
}