If you want to store images in the database, use a blob columntype.. And
take a look at this example alot of people have based mysql binary
storage off:  http://www.php4.com/forums/viewtopic.php?t=6

good luck


On Sun, 29 Jun 2003, 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]

Reply via email to