Re: 20K photos

Hi > Imagine that you want to put some 20000 historical photos On display in your website , you > use PHP and MySQL. > Preparing a photo album with 200 photos is no problem but for 20000 photos! would you do it > in the same way? Yes, but I don't necessarily see the need for a db. If you have additional information on the pictures to store, then yes, use a db. Otherwise all the info you need is available from the files. For small numbers I wouldn't store the filenames in the db. For 20K, I would. Decide on how many images per page, then use SELECT with LIMIT to pull out a page's worth of files and show the page. Back/Next tell the page what offset to use for the LIMIT clause. Niel