Extracting data from a master table?

I'm a bit overwhelmed by this forum considering my knowledge of web languages, but I figure I'll give this a shot.

Here's what I would like to do.

1. Create a master table with a large amount of data in it.
2. Create a handful of webpages that extract specific data from the master table based on specific criteria.

For example, create a table such as (weird example I know):

Item | Category | Subcategory

Milk | Dairy | Beverage
Chicken | Meat | Poultry
Eggs | Dairy |
Cookies | Junk Food |

Then generate a list or table on a webpage that extracts only items in a particular category.

It would be even better if the generated list could be sortable, but now I'm probably asking too much.

Any help would be much appreciated. Thanks in advance.

 

That is pretty easy using a SQL statement

Select item from table where category = "desired category" sort by asc/des

thats totally psuedo code.. but its not difficult to do what you are looking to acheive.

 

I gave u some rep, drbones. I highly recommend you do as above but I recommend installing an open-source script in order to build onto the structure of the script. If you build on what is in existence, it is very easy to mess with the script until it brings in the proper tables from the master tables. Feel free to PM me or ask more questions on here. Use some SQL statements/download a database script for various items.

 

thanks for the advice,
I'll give it a shot.