Re: [PHP-DB] 20K photos

[muadib]

Sorry but I don't see where the problem would be.

Aleksander

Quoting elk dolk [EMAIL PROTECTED]:


  Hi all,
 Imagine that you want to put some 2 historical photos On   
display in your website , you use PHP and MySQL.
  Preparing a photo album with 200 photos is no problem but for   
2 photos! would you do it in the same way?


  Please comment.


-
Ahhh...imagining that irresistible new car smell?
 Check outnew cars at Yahoo! Autos.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] 20K photos

[Niel Archer]

Hi

  Imagine that you want to put some 2 historical photos On display in 
 your website , you use PHP and MySQL.
   Preparing a photo album with 200 photos is no problem but for 2 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php