Posted by Jerry Stuckle on 07/05/07 14:56

cmk128@hotmail.com wrote:
> Hi
> If i execute mysql_query with this string:
> INSERT INTO `order`
> (`revisionFamily`,`revisionNumber`,`PI_ID`,`invoiceNumber`,`date`,`customerModel`,`country`,`brandname`,`productNumber`,`quantity`,`lorryType`,`deliveryDate`,`FONO`,`PONO`,`ISSUED`,`ISSUED_Department`,`fuseCustomText`,`powerCableText`,`vde`,`socketUL`,`socketCustom`,`socketCustomText`,`waveLengthAM`,`waveLengthMW`,`waveLengthFM`,`waveLengthLW`,`waveLengthSW`,`waveLengthCustom`,`waveText`,`outputW`,`cdYes`,`cdNo`,`remoteYes`,`remoteNo`,`carsetNo`,`cassetAuto`,`cassetAllStop`,`cassetHalfStop`,`cassetSoundNo`,`casset1`,`casset2`,`cassetModNo`,`cassetAC`,`cassetMagnet`,`cd33`,`cd45`,`cd78`,`cdAutoStop`,`cdText`,`led`,`ledText`,`lcd`,`backLightYes`,`backLightNo`,`backLightColor`,`dc`,`phono`,`spkJack`,`beatCut`,`75ohmApproval`,`75ohm2NonApproval`,`mic`,`6.3`,`speaker35`,`aux`,`plugOtherCheckBox`,`speakerStandard`,`speakerCustom`,`speaker1Way`,`speaker2Way`,`speaker3Way`,`speakerText`,`speakerColor`,`speakerOther`,`mainColor`,`packing`,`catalog`,`warrantyCard`,`caution`,`laserCl
ass1`,`thermalFseFitted`,`voltage`,`cablePaper`,`soundCase`,`back`,`paperText`,`dateCode`,`serialNo`,`barcodeNoLabel`,`paperOther`,`paperOtherText`,`spare2Text`,`AQL`,`outerCase`,`qcCompany`,`madeInChina`,`remarksPhoto`,`remarks`,`socketOtherRemarks`,`stockOutPhoto`,`stockOutClosing`,`stockOutETD`,`stockOutETA`,`stockOutVessel`,`stockOutInvoiceNo`,`stockOutMateReceiptDate`,`shipmentWith2Weeks`,`destination`,`LCno`,`LSD`,`ChequeNo`,`qcDate`,`qcConfirm`,`engineNotesPhoto`,`engineNotes`,`marketingNotesPhoto`,`marketingNotes`,`qcNotesPhoto`,`qcNotes`,`tips`,`warrantyCardPhoto`,`plasticBag`,`cdSheet`,`customerConfirm`,`shipHead1`,`shipHead2`,`colorA`,`QtyA`,`colorB`,`QtyB`,`colorC`,`QtyC`,`posted`,`giftBoxAttachment`,`cosmeticAttachment`,`boxAttachment`,`catalogAttachment`)
> select
> `revisionFamily`,`revisionNumber`,`PI_ID`,`invoiceNumber`,`date`,`customerModel`,`country`,`brandname`,`productNumber`,`quantity`,`lorryType`,`deliveryDate`,`FONO`,`PONO`,`ISSUED`,`ISSUED_Department`,`fuseCustomText`,`powerCableText`,`vde`,`socketUL`,`socketCustom`,`socketCustomText`,`waveLengthAM`,`waveLengthMW`,`waveLengthFM`,`waveLengthLW`,`waveLengthSW`,`waveLengthCustom`,`waveText`,`outputW`,`cdYes`,`cdNo`,`remoteYes`,`remoteNo`,`carsetNo`,`cassetAuto`,`cassetAllStop`,`cassetHalfStop`,`cassetSoundNo`,`casset1`,`casset2`,`cassetModNo`,`cassetAC`,`cassetMagnet`,`cd33`,`cd45`,`cd78`,`cdAutoStop`,`cdText`,`led`,`ledText`,`lcd`,`backLightYes`,`backLightNo`,`backLightColor`,`dc`,`phono`,`spkJack`,`beatCut`,`75ohmApproval`,`75ohm2NonApproval`,`mic`,`6.3`,`speaker35`,`aux`,`plugOtherCheckBox`,`speakerStandard`,`speakerCustom`,`speaker1Way`,`speaker2Way`,`speaker3Way`,`speakerText`,`speakerColor`,`speakerOther`,`mainColor`,`packing`,`catalog`,`warrantyCard`,`caution`,`laserCla
ss1`,`thermalFseFitted`,`voltage`,`cablePaper`,`soundCase`,`back`,`paperText`,`dateCode`,`serialNo`,`barcodeNoLabel`,`paperOther`,`paperOtherText`,`spare2Text`,`AQL`,`outerCase`,`qcCompany`,`madeInChina`,`remarksPhoto`,`remarks`,`socketOtherRemarks`,`stockOutPhoto`,`stockOutClosing`,`stockOutETD`,`stockOutETA`,`stockOutVessel`,`stockOutInvoiceNo`,`stockOutMateReceiptDate`,`shipmentWith2Weeks`,`destination`,`LCno`,`LSD`,`ChequeNo`,`qcDate`,`qcConfirm`,`engineNotesPhoto`,`engineNotes`,`marketingNotesPhoto`,`marketingNotes`,`qcNotesPhoto`,`qcNotes`,`tips`,`warrantyCardPhoto`,`plasticBag`,`cdSheet`,`customerConfirm`,`shipHead1`,`shipHead2`,`colorA`,`QtyA`,`colorB`,`QtyB`,`colorC`,`QtyC`,`posted`,`giftBoxAttachment`,`cosmeticAttachment`,`boxAttachment`,`catalogAttachment`
> from `order` where id=1
>
> I got an error, but if i execute it in mysql client, this sql is ok.
> why?
> thanks
> from Peter (cmk128@hotmail.com)
>

This isn't a PHP question. Try asking in a MySQL newsgroup - like
comp.databases.mysql. That's where the mysql experts hang out.

You will also want to post your order table definition and the error
message you get.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: Creating a vCal-interpreter
• Prev in forum: Re: carrying over variables from a form to multiple pages...
• Thread view: Re: mysql_query error

[Reply to this message]