How to list photos by category in php

[linux1880]

Hi friends,

 

I have two mysql db tables, photos and album, I would like to list photos by album how do i do that ?

 

CREATE TABLE `album` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`album_name` varchar(95) NOT NULL,
`album_desc` text NOT NULL,
PRIMARY KEY (`id`)
);



CREATE TABLE `photos` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`album_id` int(11) NOT NULL,
`thumb_name` varchar(255) NOT NULL,
`photo_name` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) 

[doddsey_65]

"SELECT * FROM photos ORDER BY album_id"

 

if you need more help let me know

[linux1880]

I would like to show the categories first when clicked show the related photos.