DesignersTalk - View Single Post

freelancr · 10-04-2008, 06:38

why use 2 tables for that? surely you could just have:

[products]
- id
- name
- type (spa, sauna, etc)
- visible

then just use this query.

Code:

SELECT * FROM `products` WHERE `visible` = '1';

10-04-2008, 06:38	#2 (permalink)
freelancr Web Developer Join Date: Oct 2006 Posts: 2,007	why use 2 tables for that? surely you could just have: [products] - id - name - type (spa, sauna, etc) - visible then just use this query. Code: SELECT * FROM `products` WHERE `visible` = '1'; KISS principle - Wikipedia, the free encyclopedia __________________ web developer