Click to See Complete Forum and Search --> : MySQL5/PHP5 Update Syntax Error 1064?


msmith29063
03-21-2010, 07:00 PM
I'm getting an error 1064 in phpMyAdmin when I use the following syntax to update a MySQL5 database table:
UPDATE trucks SET truckType='asd1', truckYear='ad1', make='asd1', model='sdf1', truckEngine='sdf1', transmission='sdf1', gvw='sdf1', axle='sdf1', mileage='sdf1', brakes='sdf1', tire='sdf1', wheel='sdf1', body='sdf1', bay='sdf1', aircond='sdf1', color='sdf1', decals='sdf1', wheelbase='sdf1', gear='sdf1', condition='sdf1', price='sdf1', units='sdf1' WHERE unit=1234
Any ideas? All the field exist in the database.

Thank you for any advice you can give.

msmith29063
03-21-2010, 09:12 PM
Thanks, guys. I didn't know condition was "taken". phpMyAdmin didn't highlight it on the error. Fixed.

ssystems
03-23-2010, 11:46 PM
Would you mind marking as resolved. Thanks