Hello all,
I haven't worked with PHP and MySQL very much, but have been working with HTML and JavaScript for years. This time, I want to build a simple website that allows users to query a database of coins. I just want to make sure that I approach this in the right direction. I'd like to describe what I'm trying to do and hopefully someone can prevent me from becoming a failure.
For the database, each coin has an ID and row, the first column of which is the date, and the following columns attributes of that particular coin. Several entries can exist with the same date.
Anyway, there will basically be three types of pages:
1. A query page from which users will click a date or enter a term in a search box.
2. A query result page displaying a list of search results, like '1909' or 'Lincoln'. Each result will be linked to an individual page for that coin.
3. An individual page. This template page will have an html table whose cells are each defined by the values for that coin in the database.
So for instance, the user searches or clicks on '1909' on the query page and sees 10 records listed in the database on the result page. The user can then click one of those 10 records and view a new page that displays more information on that particular coin.