Query: INSERT into site_request (email, pages, design, titles, header, left, centre, right, footer, extra, cost, total, request_date) VALUES ('myemail@address.com', '6', 'Surround Style', 'index, album1, album2, album3, album4, album5', 'Red', 'Green', 'White', 'No right column required!', 'Blue', 'both', '25', '150', NOW() )

// Check for a header colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['header'])))) {
  $h = escape_data($_POST['header']);
} else {
  $h = FALSE;
  echo '<p>Please enter a colour for your header section!</p>';
}

// Check for a left column colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['left'])))) {
  $l = escape_data($_POST['left']);
} else {
  $l = '<i>No left column required!</i>';
}

// Check for a centre section colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['centre'])))) {
  $c = escape_data($_POST['centre']);
} else {
  $c = FALSE;
  echo '<p>Please enter a colour for your centre section!</p>';
}

// Check for a right column colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['right'])))) {
  $r = escape_data($_POST['right']);
} else {
  $r = '<i>No right column required!</i>';
}

// Check for a footer colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['footer'])))) {
  $f = escape_data($_POST['footer']);
} else {
  $f = '<i>No footer section required!</i>';
}
$query = "INSERT into site_request (email, pages, design, titles, header, left, centre, right, footer, extra, cost, total, request_date) VALUES ('$e', '$p', '$d', '$t', '$h', '$l', '$c', '$r', '$f', '$x', '$cost', '$total', NOW() )";
$result = mysql_query ($query) or trigger_error("Query: $query\n
MySQL Error: " . mysql_error());

<p><b>Header:</b> <input type="text" name="header" size="15" maxlength="30" /></p>
<p><b>Left Column:</b> <input type="text" name="left" size="15" maxlength="32" /></p>
<p><b>Centre:</b> <input type="text" name="centre" size="15" maxlength="30" /></p>
<p><b>Right Column:</b> <input type="text" name="right" size="15" maxlength="32" /></p>
<p><b>Footer:</b> <input type="text" name="footer" size="15" maxlength="32" /></p>

'<A href="mailto:\'myemail@address.com\'">'myemail@address.com'</A>'

// Check for an email address.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*@[a-z0-9\.\-]+\.[a-z]{2,40}$', stripslashes(trim($_POST['email'])))) {
$e = escape_data($_POST['email']);
} else {
$e = FALSE;
echo '<p>Please enter a valid email address!</p>';
}

MySQL 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 'left, centre, right, footer, extra, cost, total, request_date) VALUES ('alley-ca' at line 1

<?php
ob_start();
session_start()
// Include the configuration file for error management and such.
require_once ('includes/config.inc.php');
if (isset($_POST['Send'])) { // Handle the form
require_once ('includes/mysql_connect.php'); // Connect to the database.

$d=$_POST['design'];
$x=$_POST['extra'];

// Check for an email address.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*@[a-z0-9\.\-]+\.[a-z]{2,40}$', stripslashes(trim($_POST['email'])))) {
  $e = escape_data($_POST['email']);
} else {
  $e = FALSE;
  echo '<p>Please enter a valid email address!</p>';
}

// Check for pages quantity.
if (eregi ('^[[:digit:]]{1,3}$', stripslashes(trim($_POST['pages'])))) {
  $p = escape_data($_POST['pages']);
} else {
  $p = FALSE;
  echo '<p>Please enter a number between 1 and 99!</p>';
}

if (isset($_POST['design'])) {
  $d = ($_POST['design']);
} else {
  $d = FALSE;
  echo '<p>Please select the design you require.</p>';
}</P> <P> // Check for page titles.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['titles'])))) {
  $t = escape_data($_POST['titles']);
} else {
  $t = FALSE;
  echo '<p>Please enter your titles for each page!</p>';
}

// Check for a header colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['header'])))) {
  $h = escape_data($_POST['header']);
} else {
  $h = FALSE;
  echo '<p>Please enter a colour for your header section!</p>';
}

// Check for a left column colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['left'])))) {
  $l = escape_data($_POST['left']);
} else {
  $l = '<i>No left column required!</i>';
}

// Check for a centre section colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['centre'])))) {
  $c = escape_data($_POST['centre']);
} else {
  $c = FALSE;
  echo '<p>Please enter a colour for your centre section!</p>';
}

// Check for a right column colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['right'])))) {
  $r = escape_data($_POST['right']);
} else {
  $r = '<i>No right column required!</i>';
}

// Check for a footer colour.
if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*', stripslashes(trim($_POST['footer'])))) {
  $f = escape_data($_POST['footer']);
} else {
  $f = '<i>No footer section required!</i>';
}

// Check for extra auxillary pages.

if (isset($_POST['extra'])) {
  $x = ($_POST['extra']);
} else {
  $x = FALSE;
  echo '<p>Please choose from one of the options available!</p>';
}

// Determine the Price per page.
if ($_POST['pages'] < 4) {
  $cost = 30;
} elseif ($_POST['pages'] >= 4 && $_POST['pages'] < 8) {
  $cost = 25;
} elseif ($_POST['pages'] >= 8) {
  $cost = 22.50;
}

$total = ($_POST['pages'] * $cost);
if ($e && $p && $d && $t && $h && $l && $c && $r &&  $f && $x && $cost && $total) {

$query = "SELECT user_id FROM users WHERE email='$e'";
$result = mysql_query ($query) or trigger_error("Query: $query\n
MySQL Error: " . mysql_error());
  
if (mysql_num_rows($result) < 1) {
  echo 'Only members can request this facility, please register with us before requesting a site to be built.';
} else {

// Add the request to the database.
$query = "INSERT into site_request (email, pages, design, titles, header, `left`, `centre`, `right`, `footer`, extra, cost, total, request_date) VALUES('$e', $p, '$d', '$t', '$h', '$l', '$c', '$r', '$f', '$x', $cost, $total, NOW() )";
$result = mysql_query ($query) or trigger_error("Query: $query\n
MySQL Error: " . mysql_error());

if (!$result){
  echo("Update unsuccessful");
}
$subject = "Site Creation Request";
$body = "Thank you for requesting us to build a site for you.  Although you have told us that you would like us to create $p pages at a cost of £$cost per page, there are still some details we would require from you which we will request in an forthcoming email.  The pages will be designed in the $d style, with each page using the titles, $t.  The colour scheme for the site will be $h for the header, $l for the left column, $c for the centre, $r for the right column, and $f for the footer.  The site will also contain $x supplementary page(s).";
if(!mail($e, $subject, $body)){
  print 'Your message has not been received, please try contacting us later.';
}
  
$subject = "Site Creation Request";
$body = "A request for a site to be created has been received.  The site consists of $p pages, in the $d style, using the following colour scheme: header, $h, left column, $l, centre, $c, right column, $r and footer, $f.  $x supplementary page(s) are also required.";
$recipient = "<A href="mailto:myemail@address.com">myemail@address.com</A>";

$didit = mail($recipient, $subject, $body);
if (!$didit){
  echo("Your request has not been received, please try contacting us later");
} else {
  echo("Thank you for your web site creation request, we will get back to you about further details at $e.");
}
}
}
mysql_close(); // Close the database connection.
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"<A href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd</A>">
<html xmlns="<A href="http://www.w3.org/1999/xhtml">http://www.w3.org/1999/xhtml</A>" xml:lang="en">
<head>
<title>Site Creation Request</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8"/></P> <P><meta name="keywords" content="Home-Groan, Music downloads, MP3 downloads, MP3, Music, MP3 Music downloads, Accident downloads, Accident Music downloads, Accident MP3 downloads, Accident MP3 Music downloads, HG 001, Accident Albums, Home of Accident Recordings, Alley Cat, Brill O'Padd, Alley Cat and Brill O'Padd, Alley Cat and Brill O'Padd Song Writers, Accident Fated to Happen album, Child of War, Dearest Helen, Indian Lament, Sleepless Nights, Graveyard Sign, Help Me Nurze, Harmony in B E D, Glencoe, Remembering, Lambs to the Slaughter, Girl When I Loved You, Pretty Princess, See The City, Symphony of Romance, Dancing Between Silk Sheets, Is This Our Future" /></P> <P><link href="error.css" rel="stylesheet" type="text/css"/>
</head></P> <P><body></P> <P><div class="header">
<img'><img</A> src="members/images/logo2.JPG" alt="Accident Recordings" /><p>Site Creation
Request Form</p></P> <P></div></P> <P><div class="leftcolumn">
<a href="members/index.php"><img src="members/images/logo_button.JPG" alt="Home-Groan Home" />Home</a>



<a href="members/albums.php"><img src="members/images/logo2_button.JPG" alt="Accident Albums" />Accident Albums</a>



<a href="members/screensavers.php"><img src="members/images/screen-saver_button.JPG" alt="Home-Groan Screen Savers" />Screen Savers</a>



<a href="<A href="http://jigsaw.w3.org/css-validator/">http://jigsaw.w3.org/css-validator/</A>">
  <img style="border:0;width:88px;height:31px"
       src="<A href="http://jigsaw.w3.org/css-validator/images/vcss">http://jigsaw.w3.org/css-validator/images/vcss</A>"
       alt="Valid CSS!"></img>
</a>
</p>
  
</div>
<div class="centre">
<form method="POST" action="site_request.php">
<fieldset>
<p><b>Email Address:</b> <input type="text" name="email" size="40" maxlength="40" value="<?php if (isset($_POST['email'])) echo $_POST['email']; ?>" /></p>
<p>How many HTML pages would you require?
<b>Number of Pages:</b> <input type="text" name="pages" size="3" maxlength="3" value="<?php if (isset($_POST['pages'])) echo $_POST['pages']; ?>" /> </p>
<p>Please choose the design type you require!</p>
<p><img src="members/images/page1.JPG" alt="Surround Style" />Surround Style <input type="radio" name="design" value="Surround Style" /></p>

<p><img src="members/images/page2.JPG" alt="Alternative Surround Style" />Alternative Surround Style <input type="radio" name="design" value="Alternative Surround Style" /></p>

<p><img src="members/images/page3.JPG" alt="3 Rows Style" />3 Rows Style <input type="radio" name="screen_resolution" value="3 Rows Style" /></p>

<p><img src="members/images/page4.JPG" alt="Triangle Style" />Triangle Style <input type="radio" name="design" value="Triangle Style" /></p>

<p><img src="members/images/page5.JPG" alt="Alternative Triangle Style" />Alternative Triangle Style <input type="radio" name="design" value="Alternative Triangle Style" /></p>

<p><img src="members/images/page6.JPG" alt="Left Right Style" />Left Right Style <input type="radio" name="design" value="Left Right Style" /></p>

<p><img src="members/images/page7.JPG" alt="Picture Page" />Picture Page <input type="radio" name="design" value="Picture Page" /></p>

<p><img src="members/images/page8.JPG" alt="Full Page" />Full Page <input type="radio" name="design" value="Full Page" /></p>

<p>Please enter your page titles here, separated by commas.
<b>Page Titles:</b> <textarea name="titles" cols="60" rows="5"></textarea></p>
<p>Please select the colour you require for each section of your site, you can choose either the colour name or hexadecimal number.
</p>
<p><b>Header:</b> <input type="text" name="header" size="15" maxlength="30" /></p>
<p><b>Left Column:</b> <input type="text" name="left" size="15" maxlength="32" /></p>
<p><b>Centre:</b> <input type="text" name="centre" size="15" maxlength="30" /></p>
<p><b>Right Column:</b> <input type="text" name="right" size="15" maxlength="32" /></p>
<p><b>Footer:</b> <input type="text" name="footer" size="15" maxlength="32" /></p>
<p>Do you require a Search or Contact Page?

Contact Page &nbsp; <input type="radio" name="extra" value="contact" />&nbsp; &nbsp;
Search Page &nbsp; <input type="radio" name="extra" value="search" />&nbsp; &nbsp;
Both Pages &nbsp;<input type="radio" name="extra" value="both" />&nbsp; &nbsp;
No Pages &nbsp;<input type="radio" name="extra" value="no" /></p>
</fieldset>
<p><input type="submit" name="Send" value="Place Request" /> <input type="reset" name="Submit2" value="Amend Request" /></p></form>

</body>
</html>
<?php
ob_end_flush();
?>