Re: SQL Insert problem
| From: | John W. Holmes | Date: | Thu, 05 Aug 2004 14:28:13 +0000 |
| Subject: | Re: SQL Insert problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35586@lists.php.net to get a copy of this message | ||
From: "Vincent Jordan" <vjordan@smartparts.com>
> 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...