hey guys, just a simple question for most of you... I'm just learning about php + mysql and joining of tables
I have 2 tables:
cats(categories) fields are: cat_id, cat_name
equip(equipment) fields are: eq_id, eq_name, eq_qty, cat_id
If I want to display a list of all the rows of equipment but have them broken into category sections, how would I go about doing that?
I'd like it to display like this:
TAPE MACHINES
studer std 4999 1"
panasonic gtd 14mm
MONITORS
jbl 13ft cable headphones
MIIK power amp
etc.....
thanks all!