Hi:

I finally have some free time to learn PHP, but I need a push in the right direction for something I'm working on...

I've set up a MySQL db using PHPmyAdmin; it has 4 columns (year, make, model, url). It's a table of used car inventory, so I want to be able to search by 'year,' 'make,' or model, and produce an HTML page containing the results, including the url to the page for each row returned in the search. I will be using dropdown lists with an onchange event handler to restrict searches to only the above 3 categories, but I would like to return results in descending order, either numerically, when searching by "year," or alphabetically, when searching by "make" or "model."

Here's a page containing examples of how I'd like the results returned:

http://www.ekigroup.com/table.html

A link to a good tutorial, or better yet, some sample code I can modify for my purposes will be greatly appreciated.


Thanks,


-james