RE: SQL Insert problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have inserted '$address2', correctly in the row however it is still not
putting the data in the table.

I am not getting an error but I do believe I have correct syntax set to
display problems. 

> -----Original Message-----
> From: Hutchins, Richard [mailto:Richard.Hutchins@xxxxxxxxxxxxxx]
> Sent: Thursday, August 05, 2004 10:26 AM
> To: php-db@xxxxxxxxxxxxx
> Subject: RE:  SQL Insert problem
> 
> You're missing address2 in your list of values. This means that you have
> an
> unmatching number of column names and values in your query and that'll
> make
> the query bomb.
> 
> Rich
> 
> 
> > -----Original Message-----
> > From: Vincent Jordan [mailto:vjordan@xxxxxxxxxxxxxx]
> > Sent: Thursday, August 05, 2004 10:25 AM
> > To: php-db@xxxxxxxxxxxxx
> > Subject:  SQL Insert problem
> >
> >
> > 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>
> >
> > <p>Your RMA Number is <strong> <? echo $rmanumber ?> </strong> </p>
> >
> > <p>Please include a note within your package with your
> > shipping address,
> > phone number and discription of the problem.<br />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>
> >
> >
> >
> >
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux