help in design a DB

**hisham777** · Jan 21, 2006, 12:04

her is what am trying to create
a simple online product cateloge
this is my first try to create an online application
any way
the product cateloge consite of a page of categorys a page
of products brief description about the product as well as its pic
finally the product deteils
the tables are
product category
category id (PK)
category name
date add -auto i guess its timestamp-

product description
Product id (PK)
category id
product name
product description
Image name
Image path(ascript will read the path and import the image then display it)
date add -same as above-

product deteils

product id (PK)
product name
hight
wight
etc

ok my knolewage of database design its very limited to the basics
am planning to use Mysql with PHP

any help in inhancing the design or there any errors in the cerrent
design
please help on that

and another Q
what is the Quiry that i can use it to add record in all the three table in one time (it sound stoped i guess) there are such quiry
and whats the best way to create this tables

thank you all for help.

sorry i think i have posted this in the wrong section
would you remove it to MySQL section please

**r937** · Jan 21, 2006, 15:38

your table design is fine

i would probably combine the product description and product details table

there is no query that inserts into multiple tables, you have to insert data into one table at a time

best way to create the tables is through a front end application like MySQL Query Browser or phpmyadmin or SQLyog or similar

**hisham777** · Jan 22, 2006, 04:09

thank you for reply
the query Q was necessary for me to know how to design the admin interface
and based on the answer you provided (thanks for that)
i will make 2 sections in the admin panel.
category (section)
Update
delete
Add

product details (section)
Update
delete
Add

comments are appreciated