Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the database to access the info about the picture based on the id. This

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Scott Haneda
Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the database to access the info about the picture based on the id.

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
On Thursday 21 December 2006 11:03, Scott Haneda wrote: Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Scott Haneda
What you should do, is grab the 50 images ahead of time, in one select, and use some php to iterate them and display them. Second, your suggestion is not an option in my case, since the image and the thumbnails are not stored in the database. The database contain image id, image attributes

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
On Thursday 21 December 2006 11:28, Scott Haneda wrote: What you should do, is grab the 50 images ahead of time, in one select, and use some php to iterate them and display them. Second, your suggestion is not an option in my case, since the image and the thumbnails are not stored in the