www.webdeveloper.com
Results 1 to 3 of 3

Thread: MySQL5/PHP5 Update Syntax Error 1064?

  1. #1
    Join Date
    Jan 2003
    Posts
    218

    Question MySQL5/PHP5 Update Syntax Error 1064?

    I'm getting an error 1064 in phpMyAdmin when I use the following syntax to update a MySQL5 database table:
    Code:
    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    218
    Thanks, guys. I didn't know condition was "taken". phpMyAdmin didn't highlight it on the error. Fixed.

  3. #3
    Join Date
    Oct 2009
    Posts
    658
    Would you mind marking as resolved. Thanks

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles