Code: Select all
$enterorder = "INSERT INTO orders (orderno,username,dateadded,status,archive,exvat,price,payment,cpu,memory,motherboard,usb,hdd,hdda,raid,cdrom,dvd,dvdw,gcard,gcarda,sound,modem,network,floppy,cardreader,pccase,psu,osreq,firewire,monitor,keyboard,mouse,speakers,printer,virus,office,tvcard,onsite,q,discount,total,totalexvat,deldet) VALUES ('','$mail','$datejoined','$type','','$_POST[exvat2]','$_POST[price]','Finance','$_POST[cputext]','$_POST[memtext]','$_POST[boardtext]','$_POST[usbtext]','$_POST[hddtext]','$_POST[hddatext]','$_POST[raidtext]','$_POST[cdrtext]','$_POST[dvdtext]','$_POST[dvdrwtext]','$_POST[gcardtext]','$_POST[gcardatext]','$_POST[soundtext]','$_POST[modemtext]','$_POST[nettext]','$_POST[fddtext]','$_POST[mcrtext]','$_POST[casetext]','$_POST[psutext]','$_POST[osreqtext]','$_POST[firetext]','$_POST[montext]','$_POST[keytext]','$_POST[mousetext]','$_POST[sprtext]','$_POST[pritext]','$_POST[virtext]','$_POST[offtext]','$_POST[tvctext]','$_POST[onstext]','$_POST[q]','$_POST[discount]','$_POST[final]','$_POST[extotal]','$_POST[deldet]')";
$enterq = mysql_query($enterorder, $db_conn) or die("Query enter order failed".mysql_error());