Code: Select all
mysql_query("UPDATE `intranet`.`getready` SET `deliverytype` = '$deliverytype', `plateexpdate` = '$plateexpdate', `platenumber` = '$platenumber',
`deliverydate` = '$deliverydate', `time` = '$time', `soldto` = '$soldto', `city` = '$city', zip = '$zip', `homephone` = '$homephone',
`workphone` = '$workphone', `year` = '$year', `make` = '$make', `model` = '$model', `color` = '$color',
`location` = '$location', `vin` = '$vin', `miles` = '$miles', `undercoating` = '$undercoating', `rustproofing` = '$rustproofing', `washfordelivery` = '$washfordelivery',
`fabrictreatment` = '$fabrictreatment', `washforshow` = '$washforshow', `auctiondetail` = '$auctiondetail', `fillfuel` = '$fillfuel', `fivegalfuel` = '$fivegalfuel', `bodyestimate` = '$bodyestimate',
useddetail = '$useddetail', aquapel = '$aquapel', simonize = '$simonize', service = '$service', stateinspection = '$stateinspection', emissionscheck = '$emissionscheck',
`safetycheck` = '$safetycheck', `lubeoilfilter` = '$lubeoilfilter', `oemcertify` = '$oemcertify', `universal` = '$universal', `valueserviced` = '$valueserviced', `installparts` = '$installparts',
`roadhazard` = '$roadhazard', `nitrogen` = '$nitrogen', `partnum1` = '$partnum1', `partnum2` = '$partnum2', `partdescript1` = '$partdescript1', `partdescript2` = '$partdescript2',
`partprice1` = '$partprice1', `partprice2` = '$partprice2', `other1` = '$other1', `other2` = '$other2', `other3` = '$other3', `other4` = '$other4',
`notes` = '$notes', `salesperson` = '$salesperson', `salesmanager` = '$salesmanager', `notes2` = '$notes2'
WHERE CONVERT( `getready`.`getready_id` USING utf8 ) = '$key' ");
Code: Select all
$variable = $HTTP_POST_VARS['variable'];Note: Yes I've logged in at this point and have access to what I'm updating. Also, the CONVERT part of the last line is me pretty much copying what PHPmyadmin does when it updates its own data trying to get the syntax exactly right so that my data will update properly, its probably not neccessary.