MySQL Error

I am getting this error message on the page below after I went through the wizard and the uploaded all files.

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 'desc, due_date, grade, subject, docs FROM homework LIMIT 0, 5' at line 1

homework_Results.php

looks like you have a column in your table that is named 'desc', most likely this is you description column.

the word 'desc' is a reserved word in SQL. It is used in the order by claus to have the returned records in Descending order:
ORDER BY col_name DESC


SQL Reserved words should be avoided as table names. a list of reserved words can be found here:
reserved-words.html

I have change the field name and the error is gone.

Does it matter what type the field is? I created the docs field as a blob in the db.

A blob should be fine, you could also just use a large varchar type of column.

The update and insert pages are populating the Subject dynamic menu.

homework_Results.php

Also for the update page I want to have the entered grade and subject selected, but have a complete list of the subjects and grades listed if they were entered incorrectly.

Are you keeping the possible subject and grade values in your db? If so then you will need to craft recordsets for the info from these tables to populate the select list.

On the update page you will need to select the list and in the property inspector click on the dynamic button, in here you can set the values to come from your grade or subject recordset and select the value equal to the value from your main recordset.