[eluser]Tominator[/eluser]
Yes, it means
I think it will be "fail"
I am using this model (DB):
| category |
-----------------------------
| ID | name | parent | etc (like date, who added ...)
| 1 | First | 0 | ...
| 2 | Second | 0 | ...
| 3 | Third | 2 | ...
| 4 | Fourth | 3 | ...
| 5 | NewOne | 4 | ...
| 6 | LastOne | 4 | ...
-------------------------------
##############################################
| product |
----------------------------
| ID | category | name | etc. (value, count, seo-name ...)
| 1 | 1 | First | ...
| 2 | 2|3|4|5 | Second | ...
| 2 | 2|3|4|6 | Third | ...
| 2 | 2|3|4|6 | LastOne| ...
##########################################
Your menu will be then:
- First (+ First product)
- Second
- Third
- Fourth
- NewOne (+ Second product)
- LastOne (+ Third and LastOne product)
Why this model?
When you want to show all products in some category you use:
Second category:
SELECT * FROM product WHERE category LIKE '2%'
Third category:
SELECT * FROM product WHERE category LIKE '2|3%'
etc.