It all comes down to what you are most comfortable with. What I have done is
to name each image file with a serial number (1.jpg, 2.gif, 3.png, ...) and
store the path along with the "real" name of the image in a table row. Doing
it this way means that you don't need to program logic to convert a blob in
order to serve it up with a script, you just need to programmatically create a
link to the image file and let the web server do it. I find that easier to
work with, and certainly easier to debug.
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -----Original Message-----
> From: puntapari [mailto:ibaileizea@stripped]
> Sent: Tuesday, November 20, 2007 3:38 PM
> To: mysql@stripped
> Subject: Re: IMAGES/PICTURES-MYSQL
> in this topic.
> Thank you
> View this message in context: http://www.nabble.com/IMAGES-PICTURES-
> Sent from the MySQL - General mailing list archive at Nabble.com.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1