You were missing the closing } in the else statement, and there were other error, the $qry has been changed also (no values were quoted) and in the HTML I made comments becasue your <a href's did not call a file in a couple of cases and I don't know your file so just placed a comment where needed.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org\tR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head> <title>SDASP<\title>
<link rel="stylesheet" type="text/css" href="style.css" media="screen">
<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
<style type="text/css"> #content .long { margin: 5px 25px; } #content p { margin: 0 50px } .btn { font-family:'trebuchet ms',helvetica,sans-serif; font-size:110%; font-weight:bold; background-color:#add8e6; border:1px solid #000; padding: 0 5px; margin: 0 0 10px 0; }
</style>
<?php
$hostname = "localhost";
$username = "test";
$password = "123";
$database = "scaspco_reviews";
$connection = mysql_connect($hostname ,$username , $password) or die("cannot make connection");
$db = mysql_select_db($database , $connection) or die("cannot find database");//Fixed this line (missing _)
?>
</head>
<body>
<div id="outerleft">
<div id="outerright">
<div id="header">
<?php include("header.html"); ?>
</div>
<div id="navigation">
<ul id="navlist">
<li><a href="main.shtml">Home</a></li>
<li><a href="anyboard9/forum">Available now</a></li>
<!--anyboard9/forum what(.html, .php)in above line?-->
<li><a href="reviews.shtml">Reviews</a></li>
<li><a href="anyboard9/hobbyist">Hobbyist</a></li>
<!--anyboard9/hobbist what(.html, .php)in above line?-->
<li id="chosen">Submit review</li>
<li><a href="http://www.sdasp.org/">Providers sites</a></li>
<li><a href="parachat">Chat</a></li>
<!--parachat what(.html, .php)in above line?-->
<li><a href="faq.shtml">FAQ</a></li>
<li><a href="request.shtml">Submit Webpage</a></li>
</ul>
</div>
<div id="content">
<?php
$ASP_Name = $_POST["ASP_Name"];
$ASP_City = $_POST["ASP_City"];
$ASP_Phone = $_POST["ASP_Phone"];
$Phone_Type = $_POST["Phone_Type"];
$ASP_URL = $_POST["Website_URL"];
$Informative_Website = $_POST["Informative_Website"];
$ASP_Email = $_POST["ASP_Email"];
$ASP_Type = $_POST["ASP_Type"];
$Offered_Service = $_POST["service"];
$Delivered = $_POST["Delivered"];
$On_Time = $_POST["On_Time"];
$Are_Photos_Professional = $_POST["Are_Photos_Professional"];
$Are_Photos_Current = $_POST["Are_Photos_Current"];
$How_I_Found_This_ASP = $_POST["How_I_Found_This_ASP"];
$Booking = $_POST["Booking"];
$Advertised_Length = $_POST["Advertised_Length"];
$Actual_Length = $_POST["Actual_Length"];
$Advertised_Cost = $_POST["Advertised_Cost"];
$Actual_Cost = $_POST["Actual_Cost"];
$Upselling = $_POST["Upselling"];
$Compensated = $_POST["Compensated"];
$IncallOutcall = $_POST["IncallOutcall"];
$Attitude = $_POST["Attitude"];
$Incall_Conditions = $_POST["Incall_Conditions"];
$Provided_Service = $_POST["services"];
$Strong_Point = $_POST["Strong_Point"];
$Looks = $_POST["Looks"];
$Rules = $_POST["Rules"];
$ASP_AGE = $_POST["ASP_AGE"];
$Attire = $_POST["Attire"];
$Intimate_Grooming = $_POST["Intimate_Grooming"];
$Tatoos = $_POST["Tatoos"];
$Piercings = $_POST["Piercings"];
$Scented = $_POST["Scented"];
$Smoker = $_POST["Smoker"];
$Review_For = $_POST["Review_For"];
$Made_Session = $_POST["Made_Session"];
$Again = $_POST["Again"];
$Recommend = $_POST["Recommend"];
$Username = $_POST["Username"];
$Email = $_POST["Email"];
$Display_Email = $_POST["Display_Email"];
$Age = $_POST["Age"];
$Frequent = $_POST["Frequency"];
$How_Long = $_POST["How_Long"];
$Activities = $_POST["Activities"];
$Rating = $_POST["Rating"];
echo "Date: " . $Review_Date . "><br />";
echo "ASP name: " . $ASP_Name . "><br />";
echo "City: " . $ASP_City . "><br />";
echo "ASP Phone: " . $ASP_Phone . "><br />";
echo "ASP phone type: " . $Phone_Type . "><br />";
echo "ASP website: " . $ASP_URL . "><br />";
echo "ASP website informative: " . $Informative_Website . "><br />";
echo "ASP email: " . $ASP_Email . "><br />";
echo "Agency, driver, independent? " . $ASP_Type . "><br />";
echo "Services offered: " . $O_Service . "><br />";
echo "Delivered as promised: " . $Delivered . "><br />";
echo "On-time: " . $On_Time . "><br />";
echo "Photos professional: " . $Are_Photos_Professional . "><br />";
echo "Photos current: " . $Are_Photos_Current . "><br />";
echo "How I found this ASP: " . $How_I_Found_This_ASP . "><br />";
echo "Booking: " . $Booking . "><br />";
echo "Advertised length: " . $Advertised_Length . "><br />";
echo "Actual length: " . $Actual_Length . "><br />";
echo "Advertised cost: " . $Advertised_Cost . "><br />";
echo "Actual cost: " . $Actual_Cost . "><br />";
echo "Up-selling: " . $Upselling . "><br />";
echo "Compensated: " . $Compentated . "><br />";
echo "Incall or Outcall: " . $IncallOutcall . "><br />";
echo "ASP attitude: " . $Attitude . "><br />";
echo "In-calls Conditions: " . $Incall_Conditions . "><br />";
echo "Service provided: " . $P_Service . "><br />";
echo "Strong point: " . $Strong_Point . "><br />";
echo "Looks rating: " . $Looks . "><br />";
echo "Rules: " . $Rules . "><br />";
echo "ASP age range: " . $ASP_Age . "><br />";
echo "ASP attire: " .$Attire . "><br />";
echo "Intimate grooming: " . $Intimate_Grooming . "><br />";
echo "Tatoos: " . $Tatoos . "><br />";
echo "Piercings: " . $Piercings . "><br />";
echo "Scented perfume wise: " . $Scented . "><br />";
echo "Smoke: " . $Smoker . "><br />";
echo "Review for: " . $Review_For . "><br />";
echo "Made session: " . $Made_Session . "><br />";
echo "Again: " . $Again . "><br />";
echo "Recommend this ASP: " . $Recommend . "><br />"; ; echo "Username: " . $Username . "><br />";
echo "Email: " . $Email . "><br />";
echo "Hide or display email: " . $Display_Email . "><br />";
echo "Frequency: " . $Frequent . "><br />";
echo "How long have you been in hobby: " . $How_Long . "><br />";
echo "Activities: ". $Activities . "<br />";
echo "Rating: ". $Rating;
$qry ="INSERT INTO REVIEW(R_Date,ASP_Name,ASP_City,ASP_Phone,Phone_Type,Offered_Service,Delivered,On_Time,Are_Photos_Professional,Are_Photos_Current,How_I_Found_This_ASP,Booking,Advertised_Length,Actual_Length,Advertised_Cost,Actual_Cost,Upselling,Compensated,IncallOutcall,Attitude,Incall_Conditions,Provided_Service,Strong_Point,Looks,Rules,ASP_AGE,Attire,Intimate_Grooming,Tatoos,Piercings,Breast_Size,Breast_Appearance,Scented,Smoker,Review_For,Made_Session,Again,Recommend,Username,Email,Display_Email,Age,Frequent,How_Long,Activities,Rating)VALUES('$Review_Date','$ASP_Name', '$ASP_City', '$ASP_Phone', '$Phone_Type', '$ASP_URL', '$Informative_Website', '$ASP_Email','$ASP_Type', '$Offered_Service', '$Delivered', '$On_Time', '$Are_Photos_Professional', '$Are_Photos_Current', '$How_I_Found_This_ASP', '$Booking', '$Advertised_Length', '$Actual_Length', '$Advertised_Cost', '$Actual_Cost', '$Upselling', '$Compensated', '$IncallOutcall', '$Attitude', '$Incall_Conditions', '$Provided_Service', '$Strong_Point', '$Looks', '$Rules', '$ASP_AGE', '$Attire', '$Intimate_Grooming', '$Tatoos', '$Piercings', '$Breast_Size', '$Breast_Appearance', '$Scented', '$Smoker', '$Review_For', '$Made_Session', '$Again', '$Recommend', '$Username', '$Email', '$Display_Email','$Age', '$Frequent', '$How_Long', '$Activities', '$Rating')";
$result = mysql_query($qry)or die( "Error: " . mysql_error() );
if(mysql_affected_rows() < 1) {
echo "Sorry the update did not take place";
}
else {
echo "Update successfull";
}//This was missing in your code causing the $end error
?>
</div>
<div id="footer">
<?php include("footer.html"); ?>
</div>
</div>
</div>
</body>
</html>
