list mysql data using php with sub headings?

[eddieblunt]

hi,

i've got a database table storing products for a hire company, the database is a copy of their brochure so i'm sorting by page sections so link to section 4 reads /product.php?page=4

 

 

here are the section names

 

Access Equipment 4

Breaking, Drilling & Fixing Equipment 8

Cleaning Equipment 10

Concrete / Cement Equipment 11

Masonry & Tile Equipment 12

Heating & Drying Equipment 13

Power & Site Electrical Equipment 14

Painting & Decorating Equipment 15

Roofing Equipment 16

Plumbing Equipment & Pumps 17

Engineering Equipment 18

Gardening / Landscaping Equipment 19

Woodworking Tools & Equipment 20

Welding Equipment 21

Surveyors Equipment 22

Traffic Management Equipment 23

Building & Site Equipment 24

Scaffolding & Access Systems 27

Fall Protection Systems 30

 

 

inside each of the sections there are products which need to be listed under their own sub headings

 

e.g.

 

Page 4

-ladders

  --size 1

  --size 2

  --size 3

-Platforms

  --size a

  --size b

  --size c

 

i've added a field into the database table for the sub heading but how can i list all items on each page under their own sub heading?

 

 

hope that made sense? Quite new to php so detailed help will be required!

 

 

Thanks