Projects.ADV.Databases.03

Databases Project 3:
My List Part 3

Problem

We are going to edit your list from Database Project 2 so you can run queries and sort the data by each field.

Instructions

1. Create at least two WHERE queries about your data in different PHP files.
2. At least one query should use the wildcard character.
3. At least one query should be sorted by a certain field.
4. You should create links or buttons with onclick event handlers for the different WHERE queries.
5. The links should be present on every page.
6. You should create a row at the top of your table to sort your page by each field, unless the field contains data that can't be sorted such as images. The row should contain onclick event handlers that open new PHP files with the sorted results.
7. Your page must use valid HTML and should validate using the Transitional specification. To check this you can use the Web Developer Toolbar in Firefox. Go to Tools>Validate HTML to validate your page. Your page must be uploaded for this to work.
8. Check spelling and grammar.
9. You will turn in your sites online. Mr. Miller will give you the information to do this.

Extra Credit

Get all of this working with a single PHP file. You may need to use Javascript to do this, but there are other methods.