Still learning…
Hi I am trying to make a website in PHP and MySQL using still Phakt. I was wondering due little experience in database control what is the best solution is. When does one split up a database in different tables and when do you keep it in one table. My situation -> it’s a low key website about stones. It has about 40 different kind of stones, each stone has about 10 to 15 different colours and one or maybe two pictures. For example the stone “blokformat” has 10 colours.
The benefit of using one table is for me with query’s. I don’t have to worry much about combining a query for different table’s. As I wouldn’t know how to do it. The disadvantage is that the table gets very large and so not crisp clear. About 50 fields. I don’t know if there is performance loss by using 1 table instead of 10.

What would you recommend an why. I in more table’s how would you recommend the query handling.

Thanxs!!!!!!!!!