SQL Insert problem

"Vincent Jordan" <vjordan@xxxxxxxxxxxxxx> · Thu, 5 Aug 2004 10:24:43 -0400

Im having a problem inserting data. Ive looked over this again and again and
can not find what ive missed. Everything else works besides the db insert.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>

<?php

ini_set ('display_errors', 1);

error_reporting (E_ALL & ~E_NOTICE);

// Define 

$firstname = $_POST['firstname'];

$lastname = $_POST['lastname'];

$address = $_POST['address'];

$address2 = $_POST['address2'];

$city = $_POST['city'];

$state = $_POST['state'];

$zip = $_POST['zip'];

$phone = $_POST['phone'];

$email = $_POST['email'];

$serial = $_POST['serial'];

$product = $_POST['product'];

$reason = $_POST['reason'];

$gold = $_POST['gold_button_y'];

$goldaccount = $_POST['goldaccount'];

$rmanumber = $lastname{0}.date("ndyGi");

$connect = mysql_connect("SERVER ", "USER", "PASSWORD") or die
(mysql_error());

$select = mysql_select_db ("spdata") or die (mysql_error());

$sql = "INSERT INTO rmarequest (firstname, lastname, address, address2,
city, state, zip, phone, email, serial, product, reason, rmanumber)VALUES
('$firstname', '$lastname', '$address', '$city', '$state', '$zip', '$phone',
'$email', '$serial', '$product', '$reason', '$rmanumber') or die
(mysql_error())";

if (isset($_POST['submit'])) {

$sql;

}

// Send  and put in email message

$htmlheader = "Content-Type: text/html; charset=us-ascii\n";

$htmlheader .= "Content-Transfer-Encoding: 7bit";

$header = $from; // set the from field in the header

$header .= "\n"; // add a line feed

$header .= "MIME-version: 1.0\n"; //add the mime-version header

$header .= $htmlheader."\n";

$from = "From: RMA Request <RMA@xxxxxxxxxxxxxx>";

$message = "$firstname $lastname

$address

$address2

$city

$state

$zip

$phone

$email

$product

$serial

$gold

$goldaccount

$reason

$rmanumber";

// Send email to support

mail("support@xxxxxxxxxxxxxx", "RMA Request", $message, $header);

?>

<html xmlns="http://www.w3.org/1999/xhtml";>

<head>

<title>Untitled Document</title>

</head>

<body>

<p><strong>RMA Request Sent</strong></p>

Your RMA Number is <? echo $rmanumber ?>

Please include a note within your package with your shipping address,
phone number and discription of the problem. When shipping Smart Parts
reccomends insuring your package for the full replacment cost.

    We also advise purchasing tracking services if using the postal
service.</p>

<p><strong>Ship your return to: </strong></p>

<p>Smart Parts, Inc<br />

        ATTN <? echo $rmanumber ?><br />

        Loyanhanna Business Complex<br />

        100 Station St.<br />

    Loyalhanna Pa. 15661</p>

<p><br />

  Please allow up to one week for package delivery.

    For status information please call 800-992-2147 and ask for the returns
department.</p>

<a href="#" onClick="window.print();">Click Here to print this page</a><br
/>

<a href="form.htm">Click here to return to RMA Request form</a>

</body>

</html>