Atakan Posted May 31, 2020 Share Posted May 31, 2020 (edited) Hello I want product filter groups by category. There will be different options. Ex: http://prntscr.com/sr00ay Product Table : http://prntscr.com/sr00rm Option Groups Table : http://prntscr.com/sr013r Options Table : http://prntscr.com/sr01fk Product Option Table : http://prntscr.com/sr01r3 How can I build this structure? And how should it be sql for filtering? Is the structure correct? I'm waiting for your help. Edited May 31, 2020 by Atakan Quote Link to comment Share on other sites More sharing options...
Barand Posted May 31, 2020 Share Posted May 31, 2020 If you received a message from a complete stranger, would you click on the links? 1 Quote Link to comment Share on other sites More sharing options...
Atakan Posted May 31, 2020 Author Share Posted May 31, 2020 Just now, Barand said: Tamamen bir yabancıdan bir mesaj aldıysanız, bağlantıları tıklar mıydınız? I'm sorry I couldn't add it as a picture. Links are the page of the ScreenShot program. Quote Link to comment Share on other sites More sharing options...
Barand Posted May 31, 2020 Share Posted May 31, 2020 It is possible (and preferred) for you to show table structures without pictures DESCRIBE season; +--------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------+------+-----+---------+-------+ | season | char(4) | NO | PRI | | | | season_start | date | YES | MUL | | | | season_end | date | YES | MUL | | | +--------------+---------+------+-----+---------+-------+ SHOW CREATE TABLE season; CREATE TABLE `season` ( `season` char(4) NOT NULL, `season_start` date DEFAULT NULL, `season_end` date DEFAULT NULL, PRIMARY KEY (`season`), KEY `idx_season_start` (`season_start`,`season_end`), KEY `idx_season_end` (`season_end`) ) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.