Complete n00b - Database Help

[Reality15]

Hello,

I'm working on a database for my website, and was wondering if I could get some help from you guys. I can code some basic PHP, but I really don't understand the mySQL/database portion that I need for my site.

Basically, I want a database that will allow me to add "pages" (database entries) into it through a control pannel, and then these entries can be viewable by the users. Here is a sample information I want to have in the database, all admin inputed:

ENTRY NAME: Text entry
TYPE 1: Chosen from about 50 choices
TYPE 2: Chosen from about 50 choices, based on Type 1
MANUFACTURER: Chosen from about 50 choices
MODEL: Chosen from about 50 choices, based on Manufacturer
STATUS: Chosen from 5 choices
FIELD 1: Text entry
FIELD 2: Text entry
FIELD 3: Text entry
(there may be more of these fields)

In other words, I also will need a pannel for adding types and manufacturers/models.

Is there any program that will help me out with this or must I custom code it all (in which case I have no idea how to do this)?

EDIT: There are more features that I would like to add on this, but this is the basic feature I'd like right now.

Thanks,

~ Reality

[thorpe]

no one is going to build it for you. you might try searching google for a cms, but if you want specific features, your best to just download the php manual and start reading.

[StonedDevil]

more than likely u have to learn it and make it urself, find an already written script, or pay someone to do it for u. Not that many people will write a whole script for free, at least one of that size

[Reality15]

EDIT: Alright, I've figured out how to do the basic mySQL stuff. However, is there a mySQL function that will allow me to pull out just rows (entries, whatever they may be called) in my table with the value "open" under column "status"?

[thorpe]

SELECT * FROM tbl WHERE status='open'

[Reality15]

Alright, thanks! I think I've learned the SQL statements so I can do what I want to do now.

Thanks again all!