Am trying to make a simple categorys script but am not having much luck .
CREATE TABLE `portraits` ( `n` INT(11) NOT NULL AUTO_INCREMENT, `category` VARCHAR(25) NOT NULL DEFAULT 'Main', `collection_id` VARCHAR(5) NOT NULL DEFAULT '00000', `collection_name` VARCHAR(55) NOT NULL DEFAULT 'Free Gallery 1', `permissions` INT(1) NOT NULL DEFAULT '0', PRIMARY KEY (`n`) ) ENGINE=MYISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1
above is my simple table set up basicly all I want is a category script that will check category with N and then show the collection_names that are in the same category so it would look somthing like this
Cartoon Faces: Gallery 1 Gallery 2
Flags: Gallery 1
can some one help me out, thanks