[iamcenz]

whats the best way to store images into a database?? i was thinking if there is a way to convert the image into binary, then store it in the MySQL database and then output later back as a image. but im not sure if that is even possible.

[arniie]

YES it is possible, i have done it on my latest project.

Im at home over the weekend - i can tell you EXACTLY how to do it on monday (if someone doesn't beat me to it)

IT IS DEFINATELY possible, if you want to look how to do it over the weekend

You put an image uploader on the page - they point to the file on there com. then it uploads a binary string to the db. than u call call it back on a page.

MORE INFO monday

[Cookie Mobster]

As arniie said it is very true. Images are already in binary you just have to create a blob field in your table and... well read this article.

http://www.zdnetindi...?iElementId=139

[klewlis]

While it's possible, it may not be the most practical method, depending on your purposes.

I usually just store the image name or path in the db and the actual file elsewhere.

[iamcenz]

well i guess i should tell you what im trying to do... ok, well im setting up a website calld geek gaming. its a game review site pretty much, and i need it so i have pics for every game for every console, i dont think i got that much room, on the site, i got the dream.plan on guardian hosting... but i think it would use way to much...

[Quik]

you would just have a upload field along with the title, price, etc of each game entry..

the name of the file will be placed into a field in the DB and then called later to tell the script which picture to grab from a specific directory.

[arniie]

Blunted: did you get this sorted or ??

[agazeus]

Just have them all in numerical order(named), and then have the db indexed - Just have the path there and it loads it with whatever record you are viewing. Storing it in binary might make it a bit big - yes?