Section Sql = SELECT * FROM `sections` WHERE `id` = '58'
Product Sql = SELECT products.* FROM `products` INNER JOIN `sections` ON products.section = sections.id WHERE products.section = '58' AND products.showonweb = 'Yes' AND sections.showonweb = 'Yes' ORDER BY `sort`, `name`

Number of products found: 5

Abstract Silk Wrap
Abstract Silk Wrap
Abstract Silk Wrap

from £38.00

Long Cat Scarf
Long Cat Scarf
Long Cat Scarf

from £32.00

Square Cat Scarf
Square Cat Scarf
Square Cat Scarf

from £32.00

Scarves from ShonaD