Jump to content

How to list photos by category in php


linux1880

Recommended Posts

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`)
) 


Link to comment
https://forums.phpfreaks.com/topic/215261-how-to-list-photos-by-category-in-php/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.