> i have number of jpg images. I want to store these images in > mysql,retreive on webpage, then to download the particular image whom > visitor click.
Never store binary data in a database if you can avoid it. There are a lot of reasons. The most important ones: Space requirement (mysql has to encode) Performance (a database needs to query, decode and send data) Backup Speed (mysqldump into csv and binary data do not work well) Just store the images outside the document root and use a php file to passthru. Doing so is more performant and can be secured. HTH, Patrick