Bob: This question comes up over and over on the list ... do a search for 'images' of the list archive and you can read the accumulated pros and cons.
Gerald Jensen ----- Original Message ----- From: "Bob Ostermann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 7:35 AM Subject: Re: inserting images to mysql - is it possible? > Armand- > > Why is it not recommended to store images in a database? I've not heard this... > > > bob. > > > > At 09:51 PM 6/29/03 +0200, you wrote: > >Hi, > >You have to insert a new blob field where you can store binary data. But > >it is not recommanded to store images in a database. I recommande you to > >store images on a server filesystem and only the reference to the images > >in a database. > > > >Armand > > > >Digital Directory USA wrote: > > > >>I am new to php and mysql, I have searched looked over and cannot find a > >>way to do this... can it be done? I have set up the following in mysql. > >>How do I upload the product images to the pPhoto column. Any suggestions? > >>ds_produc > >> Field Type Attributes Null Default Extra > >> pID int(11) No auto_increment > >> catID int(11) No 0 > >> pName varchar(70) Yes NULL > >> pNum varchar(40) Yes NULL > >> pTeaser text No > >> pDesc text Yes NULL > >> pPrice float(10,2) Yes NULL > >> pSalesPrice float(10,2) No 0.00 > >> pSale char(1) No > >> pPhoto varchar(70) Yes NULL > >> pPhotoWidth int(11) No 0 > >> pPhotoHeight int(11) No 0 > >> pSize varchar(35) Yes NULL > >> pAvail char(1) No Y > >> > >> > >>George Guebely > >>Digital Directory USA, Inc > >> > >> > > > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > ============================================== > The RediNews Network http://www.redinews.com/ > Custom Financial Web Site Content > phone: (516) 997-4343 > ============================================== > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]