[Resolved] This should be simple.

rockerscc

Maybe someone else can see something I am not. When I submit the form I get the message below. The year column produces the same error with its properties as both text and date format

This syntax:
$sql = "INSERT INTO bike_app (year, make, model, engine_size, full_coverage, towing, um, leinholder, name, address, city, state, zip, phone, time, email, tickets, accidents, dui, experience, usage, annual_miles, one_way, new, sold, date) VALUES ('$bike_year', '$make', '$model', '$engine_size', '$full_coverage', '$towing', '$um', '$leinholder', '$name', '$address', '$city', '$state', '$zip', '$phone', '$time', '$email', '$tickets', '$accidents', '$dui', '$experience', '$usage', '$annual_miles', '$one-way', 'y', 'n', '$today')";

Gets this error message:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'usage, annual_miles, one_way, new, sold, date) VALUES ('1980',

eoghain

Usage is a key word http://dev.mysql.com/doc/maxdb/en/b6/020c053f5e11d3aa26006094b92fad/content.htm

mourisj

This message does NOT mean that the error happens at this exact place !
MySql guesses at its best knowledge that it might happen somewhere around there! Sometimes, the error is at another place: if you have a wrong datatype for one field, or the number oof fields doesn't match, MySql finds the error at another place where it really happens!

Make sure you don't run into trouble with your date, time and name fields, which might be resrved words; I never use these in a database to avoid trouble.

Do an Echo of your statement with values filled in, as it would be submitted to the DB (eventually, post the full statement here); check it again for errors, and try to submit your query directly to the database. Maybe you get more detailed error messages there.

Also make sure you don't have quotes in the submitted data: MySql will run into trouble as it interpretes quotes as the end of a string: number of fields or quotation of fields will be wrong.

Hope this helps.

JJ Mouris

rockerscc

using the word usage was the problem. thanks. I've never heard of that.