Error while inserting data into mysql

am 01.03.2011 11:25:16 von Nagendra Prasad

--e0cb4e887675c70504049d693825
Content-Type: text/plain; charset=ISO-8859-1

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.

--e0cb4e887675c70504049d693825--

Re: Error while inserting data into mysql

am 01.03.2011 11:39:22 von Richard Quadling

On 1 March 2011 10:25, nagendra prasad 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

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

Re: Error while inserting data into mysql

am 01.03.2011 11:59:26 von Nagendra Prasad

--e0cb4e8876755269ee049d69b39a
Content-Type: multipart/alternative; boundary=e0cb4e8876755269e2049d69b398

--e0cb4e8876755269e2049d69b398
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

I have attached the table structure and the PHP code.

Best,
Guru.

--e0cb4e8876755269e2049d69b398
Content-Type: text/html; charset=ISO-8859-1

Hi All,

I have attached the table structure and the PHP code.

Best,
Guru.

--e0cb4e8876755269e2049d69b398--
--e0cb4e8876755269ee049d69b39a
Content-Type: text/plain; charset=US-ASCII; name="table structure.txt"
Content-Disposition: attachment; filename="table structure.txt"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_gkqpg4v60

PT09RGF0YWJhc2UgZHJlYW0NCg0KPT0gVGFibGUgc3RydWN0dXJlIGZvciB0 YWJsZSBkcmVhbQ0K
DQp8LS0tLS0tDQp8RmllbGR8VHlwZXxOdWxsfERlZmF1bHQNCnwtLS0tLS0N Cnxtd29vbDQwfHZh
cmNoYXIoMTAwKXxZZXN8TlVMTA0KfGd3b29sMjV8dmFyY2hhcigxMDApfFll c3xOVUxMDQp8d21l
c2gyNHx2YXJjaGFyKDEwMCl8WWVzfE5VTEwNCnxzaGtvdGUzMHx2YXJjaGFy KDEwMCl8WWVzfE5V
TEwNCnxzY2xvdGgxMDB8dmFyY2hhcigxMDApfFllc3xOVUxMDQp8bWFjb21w NDB8dmFyY2hhcigx
MDApfFllc3xOVUxMDQp8cG9wfHZhcmNoYXIoMTAwKXxZZXN8TlVMTA0KfGhj bG90aDk1fHZhcmNo
YXIoMTAwKXxZZXN8TlVMTA0KfG13b29sNDBfcXR5fGludCgxMCl8WWVzfE5V TEwNCnxnd29vbDI1
X3F0eXxpbnQoMTApfFllc3xOVUxMDQp8d21lc2gyNF9xdHl8aW50KDEwKXxZ ZXN8TlVMTA0KfHNo
a290ZTMwX3F0eXxpbnQoMTApfFllc3xOVUxMDQp8bWFjb21wNDBfcXR5fGlu dCgxMCl8WWVzfE5V
TEwNCnxwb3BfcXR5fGludCgxMCl8WWVzfE5VTEwNCnxoY2xvdGg5NV9xdHl8 aW50KDEwKXxZZXN8
TlVMTA0KfG13b29sNDBfdXRwfGludCgyMCl8WWVzfE5VTEwNCnxnd29vbDI1 X3V0cHxpbnQoMjAp
fFllc3xOVUxMDQp8d21lc2gyNF91dHB8aW50KDIwKXxZZXN8TlVMTA0KfHNo a290ZTMwX3V0cHxp
bnQoMjApfFllc3xOVUxMDQp8c2Nsb3RoMTAwX3V0cHxpbnQoMjApfFllc3xO VUxMDQp8bWFjb21w
NDBfdXRwfGludCgyMCl8WWVzfE5VTEwNCnxwb3BfdXRwfGludCgyMCl8WWVz fE5VTEwNCnxoY2xv
dGg5NV91dHB8aW50KDIwKXxZZXN8TlVMTA0KfG13b29sNDBfdmFsfGludCgy MCl8WWVzfE5VTEwN
Cnxnd29vbDI1X3ZhbHxpbnQoMjApfFllc3xOVUxMDQp8d21lc2gyNF92YWx8 aW50KDIwKXxZZXN8
TlVMTA0KfHNoa290ZTMwX3ZhbHxpbnQoMjApfFllc3xOVUxMDQp8c2Nsb3Ro MTAwX3ZhbHxpbnQo
MjApfFllc3xOVUxMDQp8bWFjb21wNDBfdmFsfGludCgyMCl8WWVzfE5VTEwN Cnxwb3BfdmFsfGlu
dCgyMCl8WWVzfE5VTEwNCnxoY2xvdGg5NV92YWx8aW50KDIwKXxZZXN8TlVM TA0KfG13b29sNDBf
dmF0cnxpbnQoMTApfFllc3xOVUxMDQp8Z3dvb2wyNV92YXRyfGludCgxMCl8 WWVzfE5VTEwNCnx3
bWVzaDI0X3ZhcnJ8aW50KDEwKXxZZXN8TlVMTA0KfHNoa290ZTMwX3ZhdHJ8 aW50KDEwKXxZZXN8
TlVMTA0KfHNjbG90aDEwMF92YXRyfGludCgxMCl8WWVzfE5VTEwNCnxtYWNv bXA0MF92YXRyfGlu
dCgxMCl8WWVzfE5VTEwNCnxwb3BfdmF0cnxpbnQoMTApfFllc3xOVUxMDQp8 aGNsb3RoOTVfdmF0
cnxpbnQoMTApfFllc3xOVUxMDQp8bXdvb2w0MF92YXRwfGludCgyMCl8WWVz fE5VTEwNCnxnd29v
bDI1X3ZhdHB8aW50KDIwKXxZZXN8TlVMTA0KfHdtZXNoMjRfdmF0cHxpbnQo MjApfFllc3xOVUxM
DQp8c2hrb3RlMzBfdmF0cHxpbnQoMjApfFllc3xOVUxMDQp8c2Nsb3RoMTAw X3ZhdHB8aW50KDIw
KXxZZXN8TlVMTA0KfG1hY29tcDQwX3ZhdHB8aW50KDIwKXxZZXN8TlVMTA0K fHBvcF92YXRwfGlu
dCgyMCl8WWVzfE5VTEwNCnxoY2xvdGg5NV92YXRwfGludCgyMCl8WWVzfE5V TEwNCnxtd29vbDQw
X3RvdGFtdHxpbnQoMjApfFllc3xOVUxMDQp8Z3dvb2wyNV90b3RhbXR8aW50 KDIwKXxZZXN8TlVM
TA0KfHdtZXNoMjRfdG90YW10fGludCgyMCl8WWVzfE5VTEwNCnxzaGtvdGUz MF90b3RhbXR8aW50
KDIwKXxZZXN8TlVMTA0KfHNjbG90aDEwMF90b3RhbXR8aW50KDIwKXxZZXN8 TlVMTA0KfG1hY29t
cDQwX3RvdGFtdHxpbnQoMjApfFllc3xOVUxMDQp8cG9wX3RvdGFtdHxpbnQo MjApfFllc3xOVUxM
DQp8aGNsb3RoOTVfdG90YW10fGludCgyMCl8WWVzfE5VTEwNCnx0b3RhbHxp bnQoMjApfFllc3xO
VUxMDQp8dHJhbnNfY2hnc3xpbnQoMTUpfFllc3xOVUxMDQp8Z3RvdGFsfGlu dCgyMCl8WWVzfE5V
TEwNCnxydXBlZXN8dmFyY2hhcigxMDApfFllc3xOVUxMDQp8Ly8qKnBhcnR5 X25hbWUqKi8vfHZh
cmNoYXIoNDAwKXxOb3wNCnx0aW5fbm98dmFyY2hhcig1MCl8WWVzfE5VTEwN CnxpbnZvaWNlX25v
fHZhcmNoYXIoNTApfFllc3xOVUxMDQp8aW52b2ljZV9kYXRlfHZhcmNoYXIo MjApfFllc3xOVUxM
DQp8b3JkZXJfbm98dmFyY2hhcigxNSl8WWVzfE5VTEwNCnxvcmRlcl9kYXRl fHZhcmNoYXIoMjAp
fFllc3xOVUxMDQp8ZGNfbm98dmFyY2hhcigyMCl8WWVzfE5VTEwNCnxkY19k YXRlfHZhcmNoYXIo
MTUpfFllc3xOVUxMDQo9PSBEdW1waW5nIGRhdGEgZm9yIHRhYmxlIGRyZWFt DQoNCg==
--e0cb4e8876755269ee049d69b39a
Content-Type: text/plain; charset=US-ASCII; name="php_code.txt"
Content-Disposition: attachment; filename="php_code.txt"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_gkqpg9871

PD9waHANCiRjb24gPSBteXNxbF9jb25uZWN0KCJsb2NhbGhvc3QiLCJyb290 IiwiIik7DQppZiAo
ISRjb24pDQogIHsNCiAgZGllKCdDb3VsZCBub3QgY29ubmVjdDogJyAuIG15 c3FsX2Vycm9yKCkp
Ow0KICB9DQoNCm15c3FsX3NlbGVjdF9kYigiZHJlYW0iLCAkY29uKTsNCg0K JHNxbD0iSU5TRVJU
IElOVE8gZHJlYW0gKG13b29sNDAsIGd3b29sMjUsIHdtZXNoMjQsIHNoa290 ZTMwLCBzY2xvdGgx
MDAsIG1hY29tcDQwLCBwb3AsIGhjbG90aDk1LCBtd29vbDQwX3F0eSwgZ3dv b2wyNV9xdHksIHdt
ZXNoMjRfcXR5LCBzaGtvdGUzMF9xdHksIHNjbG90aDEwMF9xdHksIG1hY29t cDQwX3F0eSwgcG9w
X3F0eSwgaGNsb3RoOTVfcXR5LCBtd29vbDQwX3V0cCwgZ3dvb2wyNV91dHAs IHdtZXNoMjRfdXRw
LCBzaGtvdGUzMF91dHAsIHNjbG90aDEwMF91dHAsIG1hY29tcDQwX3V0cCwg cG9wX3V0cCwgaGNs
b3RoOTVfdXRwLCBtd29vbDQwX3ZhbCwgZ3dvb2wyNV92YWwsIHdtZXNoMjRf dmFsLCBzaGtvdGUz
MF92YWwsIHNjbG90aDEwMF92YWwsIG1hY29tcDQwX3ZhbCwgcG9wX3ZhbCwg aGNsb3RoOTVfdmFs
LCBtd29vbDQwX3ZhdHIsIGd3b29sMjVfdmF0ciwgd21lc2gyNF92YXRyLCBz aGtvdGUzMF92YXRy
LCBzY2xvdGgxMDBfdmF0ciwgbWFjb21wNDBfdmF0ciwgcG9wX3ZhdHIsIGhj bG90aDk1X3ZhdHIs
IG13b29sNDBfdmF0cCwgZ3dvb2wyNV92YXRwLCB3bWVzaDI0X3ZhdHAsIHNo a290ZTMwX3ZhdHAs
IHNjbG90aDEwMF92YXRwLCBtYWNvbXA0MF92YXRwLCBwb3BfdmF0cCwgaGNs b3RoOTVfdmF0cCwg
bXdvb2w0MF90b3RhbXQsIGd3b29sMjVfdG90YW10LCB3bWVzaDI0X3RvdGFt dCwgc2hrb3RlMzBf
dG90YW10LCBzY2xvdGgxMDBfdG90YW10LCBtYWNvbXA0MF90b3RhbXQsIHBv cF90b3RhbXQsIGhj
bG90aDk1X3RvdGFtdCwgdG90YWwsIHRyYW5zX2NoZ3MsIGd0b3RhbCwgcnVw ZWVzLCBwYXJ0eV9u
YW1lLCB0aW5fbm8sIGludm9pY2Vfbm8sIGludm9pY2VfZGF0ZSwgb3JkZXJf bm8sIG9yZGVyX2Rh
dGUsIGRjX25vLCBkY19kYXRlKQ0KVkFMVUVTDQooJyRfUE9TVFttd29vbDQw XScsJyRfUE9TVFtn
d29vbDI1XScsJyRfUE9TVFt3bWVzaDI0XScsJyRfUE9TVFtzaGtvdGUzMF0n LCckX1BPU1Rbc2Ns
b3RoMTAwXScsJyRfUE9TVFttYWNvbXA0MF0nLCckX1BPU1RbcG9wXScsJyRf UE9TVFtoY2xvdGg5
NV0nLCckX1BPU1RbbXdvb2w0MF9xdHldJywnJF9QT1NUW2d3b29sMjVfcXR5 XScsJyRfUE9TVFt3
bWVzaDI0X3F0eV0nLCckX1BPU1Rbc2hrb3RlMzBfcXR5XScsJyRfUE9TVFtz Y2xvdGgxMDBfcXR5
XScsJyRfUE9TVFttYWNvbXA0MF9xdHldJywnJF9QT1NUW3BvcF9xdHldJywn JF9QT1NUW2hjbG90
aDk1X3F0eV0nLCckX1BPU1RbbXdvb2w0MF91dHBdJywnJF9QT1NUW2d3b29s MjVfdXRwXScsJyRf
UE9TVFt3bWVzaDI0X3V0cF0nLCckX1BPU1Rbc2hrb3RlMzBfdXRwXScsJyRf UE9TVFtzY2xvdGgx
MDBfdXRwXScsJyRfUE9TVFttYWNvbXA0MF91dHBdJywnJF9QT1NUW3BvcF91 dHBdJywnJF9QT1NU
W2hjbG90aDk1X3V0cF0nLCckX1BPU1RbbXdvb2w0MF92YWxdJywnJF9QT1NU W2d3b29sMjVfdmFs
XScsJyRfUE9TVFt3bWVzaDI0X3ZhbF0nLCckX1BPU1Rbc2hrb3RlMzBfdmFs XScsJyRfUE9TVFtz
Y2xvdGgxMDBfdmFsXScsJyRfUE9TVFttYWNvbXA0MF92YWxdJywnJF9QT1NU W3BvcF92YWxdJywn
JF9QT1NUW2hjbG90aDk1X3ZhbF0nLCckX1BPU1RbbXdvb2w0MF92YXRyXScs JyRfUE9TVFtnd29v
bDI1X3ZhdHJdJywnJF9QT1NUW3dtZXNoMjRfdmF0cl0nLCckX1BPU1Rbc2hr b3RlMzBfdmF0cl0n
LCckX1BPU1Rbc2Nsb3RoMTAwX3ZhdHJdJywnJF9QT1NUW21hY29tcDQwX3Zh dHJdJywnJF9QT1NU
W3BvcF92YXRyXScsJyRfUE9TVFtoY2xvdGg5NV92YXRyXScsJyRfUE9TVFtt d29vbDQwX3ZhdHBd
JywnJF9QT1NUW2d3b29sMjVfdmF0cF0nLCckX1BPU1Rbd21lc2gyNF92YXRw XScsJyRfUE9TVFtz
aGtvdGUzMF92YXRwXScsJyRfUE9TVFtzY2xvdGgxMDBfdmF0cF0nLCckX1BP U1RbbWFjb21wNDBf
dmF0cF0nLCckX1BPU1RbcG9wX3ZhdHBdJywnJF9QT1NUW2hjbG90aDk1X3Zh dHBdJywnJF9QT1NU
W213b29sNDBfdG90YW10XScsJyRfUE9TVFtnd29vbDI1X3RvdGFtdF0nLCck X1BPU1Rbd21lc2gy
NF90b3RhbXRdJywnJF9QT1NUW3Noa290ZTMwX3RvdGFtdF0nLCckX1BPU1Rb c2Nsb3RoMTAwX3Rv
dGFtdF0nLCckX1BPU1RbbWFjb21wNDBfdG90YW10XScsJyRfUE9TVFtwb3Bf dG90YW10XScsJyRf
UE9TVFtoY2xvdGg5NV90b3RhbXRdJywnJF9QT1NUW3RvdGFsXScsJyRfUE9T VFt0cmFuc19jaGdz
XScsJyRfUE9TVFtndG90YWxdJywnJF9QT1NUW3J1cGVlc10nLCckX1BPU1Rb cGFydHlfbmFtZV0n
LCckX1BPU1RbdGluX25vXScsJyRfUE9TVFtpbnZvaWNlX25vXScsJyRfUE9T VFtpbnZvaWNlX2Rh
dGVdJywnJF9QT1NUW29yZGVyX25vXScsJyRfUE9TVFtvcmRlcl9kYXRlXScs JyRfUE9TVFtkY19u
b10nLCckX1BPU1RbZGNfZGF0ZV0nKSI7DQoNCmlmICghbXlzcWxfcXVlcnko JHNxbCwkY29uKSkN
CiAgew0KICBkaWUoJ0Vycm9yOiAnIC4gbXlzcWxfZXJyb3IoKSk7DQogIH0N CmVjaG8gIjEgcmVj
b3JkIGFkZGVkIjsNCg0KbXlzcWxfY2xvc2UoJGNvbikNCj8+IA==

--e0cb4e8876755269ee049d69b39a
Content-Type: text/plain; charset=us-ascii

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

Re: Error while inserting data into mysql

am 01.03.2011 11:59:26 von Nagendra Prasad

Re: Re: Error while inserting data into mysql

am 01.03.2011 12:07:27 von Richard Quadling

On 1 March 2011 10:59, nagendra prasad wrote:
> Hi All,
>
> I have attached the table structure and the PHP code.
>
> Best,
> Guru.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Thank you for that.

Can you tell me what column in the table is scloth100_qty? I can't find it.

--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY

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

Re: Re: Error while inserting data into mysql

am 01.03.2011 12:07:27 von Richard Quadling

Re: Re: Error while inserting data into mysql

am 01.03.2011 12:09:36 von Richard Quadling

On 1 March 2011 10:59, nagendra prasad wrote:
> Hi All,
>
> I have attached the table structure and the PHP code.
>
> Best,
> Guru.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

The scloth100 columns I can see are ...

|scloth100_totamt|int(20)|Yes|NULL
|scloth100_utp|int(20)|Yes|NULL
|scloth100_val|int(20)|Yes|NULL
|scloth100_vatp|int(20)|Yes|NULL
|scloth100_vatr|int(10)|Yes|NULL
|scloth100|varchar(100)|Yes|NULL

No scloth100_qty.

--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY

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

Re: Re: Error while inserting data into mysql

am 01.03.2011 12:09:36 von Richard Quadling

On 1 March 2011 10:59, nagendra prasad wrote:
> Hi All,
>
> I have attached the table structure and the PHP code.
>
> Best,
> Guru.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

The scloth100 columns I can see are ...

|scloth100_totamt|int(20)|Yes|NULL
|scloth100_utp|int(20)|Yes|NULL
|scloth100_val|int(20)|Yes|NULL
|scloth100_vatp|int(20)|Yes|NULL
|scloth100_vatr|int(10)|Yes|NULL
|scloth100|varchar(100)|Yes|NULL

No scloth100_qty.

--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY

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

Re: Re: [PHP-WIN] Re: Error while inserting data intomysql

am 01.03.2011 12:23:14 von Geoff Lane

On Tuesday, March 1, 2011, Richard Quadling wrote;

> Can you tell me what column in the table is scloth100_qty? I can't find it.

The issue here is probably that you have some PHP code that is passing
a SELECT statement to MySQL and that SELECT includes scloth100_qty in
its column list. One debugging technique that I find useful in such
situations is to echo the query to the output web page. So, if your
original code was:

$result_table = mysql_query ($query, $link);

Then you might try inserting the line:

echo "

$query

";

immediately before the call to mysql_query, i.e.:

echo "

$query

";
$result_table = mysql_query ($query, $link);

You can then examine the actual query being passed to MySQL and work
backwards from there to correct the issue.

HTH,

--
Geoff

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

Re: Re: [PHP-WIN] Re: Error while inserting data into mysql

am 01.03.2011 12:32:43 von Nagendra Prasad

--e0cb4e887675cb820f049d6a2a34
Content-Type: text/plain; charset=ISO-8859-1

Thanks Geoff Lane, I saw my mistake. Their was no scloth100_qty in my mysql
table. Once again Thanks buddy :)

On Tue, Mar 1, 2011 at 4:53 PM, Geoff Lane wrote:

> On Tuesday, March 1, 2011, Richard Quadling wrote;
>
> > Can you tell me what column in the table is scloth100_qty? I can't find
> it.
>
> The issue here is probably that you have some PHP code that is passing
> a SELECT statement to MySQL and that SELECT includes scloth100_qty in
> its column list. One debugging technique that I find useful in such
> situations is to echo the query to the output web page. So, if your
> original code was:
>
> $result_table = mysql_query ($query, $link);
>
> Then you might try inserting the line:
>
> echo "

$query

";
>
> immediately before the call to mysql_query, i.e.:
>
> echo "

$query

";
> $result_table = mysql_query ($query, $link);
>
> You can then examine the actual query being passed to MySQL and work
> backwards from there to correct the issue.
>
> HTH,
>
> --
> Geoff
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--e0cb4e887675cb820f049d6a2a34--