SELECT * FROM products JOIN category ON products.cat_id = category.cat_id HAVING status='1' ORDER BY products.status, category.cat_name ASC Products | CTW International
 

Products

Abrasives
Accessories
Bonding & Sealing
Booth Coating & Liquids
Mixing Cups
Paint Suits & Lab Coats
Putties/Fillers
Safety / Cleaning
Spray Bottles & Touch Up Kits
Spray Cards
Spreaders/Squeegees
Strainers & Paint Paddles
Tape
Undercoating

 

top