Im having issues trying to make a product catalog. Im using mySQL for the database using php to query. My database structure is terrible but being in a hurry i structured it into 6 separate tables. One per parent product.
Carpet
Hardwood
Tile
ect..
Im using a form input and a option field to search the database. The option field has 7 options(All products, carpet, hardwood, tile, laminate, ect). I need alot of work on this portion too and sugestions would be appreciated. My codes a mess and incomplete but ill post what i have at the bottom.
The second question and the main reason im posting is i cant find a good way to query all tables. I realize that a proper structure would solve this but iv had little luck in finding a solution with my amount of experience. Iv settled on this for not knowing of a better option.
Im in way over my head and any help would be very appreciated. Ill link to my php code and the live page.
tl;dr Need to query 6 tables for lack of a better option. Suggestions on my code are appreciated because its work in progress and mess.
http://www.deerfootcarpet.com/search/search.php
Thanks,
Nathen
Carpet
Hardwood
Tile
ect..
Im using a form input and a option field to search the database. The option field has 7 options(All products, carpet, hardwood, tile, laminate, ect). I need alot of work on this portion too and sugestions would be appreciated. My codes a mess and incomplete but ill post what i have at the bottom.
The second question and the main reason im posting is i cant find a good way to query all tables. I realize that a proper structure would solve this but iv had little luck in finding a solution with my amount of experience. Iv settled on this for not knowing of a better option.
Code:
select * FROM carpet, hardwood, tile where match(name, color, manufacturer, brand, fibre, store_stock, specials, room_type, pattern_repeat, size, samples_avalible, product_style, product_usage, reviews, p_info, price, warranty) against ('*$find*' IN BOOLEAN MODE);"
Im in way over my head and any help would be very appreciated. Ill link to my php code and the live page.
tl;dr Need to query 6 tables for lack of a better option. Suggestions on my code are appreciated because its work in progress and mess.
http://www.deerfootcarpet.com/search/search.php
Thanks,
Nathen
Last edited: