Saving picture / files to mySQL

[Anon]

Hi there,

Is there any way to save an uploaded file - specifically, an image, to a mysql database? If so have can i save it, and how do i retrieve it.

Thanks lots for any help given.

[cybersami]

You can insert any image to mysql databse by following way:

mysql_query("create tabletable_name(field_name BLO😎");
mysql_query("insert into table_name(field_name) values('image_file.ext')");

'BLOB' is a image datatype.

[Anon]

Thanks a lot. And if i want to retrieve it, will it pass the file back out as an image?
How would i put it into html?

Thanks for any extra help