Re: Error while inserting data into mysql
| From: | Richard Quadling | Date: | Tue, 01 Mar 2011 10:39:22 +0000 |
| Subject: | Re: Error while inserting data into mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47699@lists.php.net to get a copy of this message | ||
On 1 March 2011 10:25, nagendra prasad <nagendra802000@gmail.com> wrote:
> Hi All,
>
> I have 2 simple php pages. One with the form just like some sales voucher.
> Another is to print in a proper format and to insert the form database into
> mysql. When I enter some data in the sales voucher everything is going well,
> however when it comes to the second php for inserting data into mysql I am
> getting an error like "Error: Unknown column 'scloth100_qty' in 'field
> list'". I have checked everything but not sure about the error. Please help
> me with it.
>
> Best,
> Guru.
>
You have some PHP code.
It is attempting to write to a mysql table.
One of the columns you've coded for doesn't exist. Maybe.
Can you show us the table structure and the exact SQL statement you
are executing please?
Richard.
--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY