Re: SQL Insert problem

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

 



From: "Vincent Jordan" <vjordan@xxxxxxxxxxxxxx>

> 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.

It would have helped if you told us the error you got was "column count does
not match value count" or something similar...

> $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())";

You list 13 columns to insert into but only give 12 values.

---John Holmes...

-- 
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