MySQL dynamic images

[PHTech]

Hi there...

How do I specify a path in a MySQL DB to store the location of an image to use in my website...?

At this stage i manually insert the path into the DB for the image file, but I do not know as what format the field in the MySQL should be (VARCHAR, BLOB...?)

Any help would be appreciated!!!

Thanx....

 

[Simoski]

if you want to store the path to the images then use varchar.
if you want to store the images themselves use a blob.
I don't suggest storing the images within the database as then it will be difficult to change them quickly.

 

[Simoski]

I do have some c code to do it if you really want to though... let me know simon ( @ ) thinkmoney [dot]co[dot]za