PHP project

[DeepBlerg]

In a few months time I will be creating a site and I'd like to use PHP & PostgreSQL because of their flexibility.

The site will consist of some 200 - 300 images all the same size, displayed alphabetically (10 per page or all per letter depending on how the user wants to view them). Occassionally new images will be added so that won't be a problem since the pages won't be static, instead created on-the-fly.

My question is how will I create this solution? Should I store the image names in the database and call 10 or all at a time depending on what the user wants?

All I basically need is a few pointers since I am new to PHP & PostgreSQL.

Thanks in advance.

 

[inlandpac]

I would store the image INFORMATION (name, location, keywords, description, credits, etc) in the database and the images within the filesystem. This will provide you with the most flexibility and speed.

This seems like a pretty simple project and you should be able to come up with a solution in no time at all.

Chad. ICQ: 54380631

 

[mcvdmvs]

A little help for selection of the images, in a postgresql select you can define offset and limit, so pull out 10 images as a time, and not all 300.
: mcvdmvs
-- "It never hurts to help" -- Eek the Cat

 

[inlandpac]

Such as

'SELECT * FROM my_images LIMIT 10'
(select 10 rows starting from the 1st row)

or

'SELECT * FROM my_images LIMIT 10,10'
(select 10 rows starting at the 10th row)

and so on....

Chad. ICQ: 54380631