PHP MySQL GALLERY

[LRNPHP]

Hi Everyone.

I have MySQL db with images in(MEDIUMBLOB); I would to display the images in a gallery fashion with a MySQL select command.

Any help would be appreciated.

Regards

[theighost]

put the paths in the database, put the a column for ordering the images in the gallery, the id of the image for example, or the day the image was added.

then in the slide show select from the database by ordering according the column (the id, or the adding date).

you can use ajax to swithc between images, or a function that returns the next image and another one that returns the previous image (php, or other server side language).

you have to use your imagination to make these things, when you're stuck in a point write here and people can answer your questions easily, a general question is hard to be answered :)

[vibhaJ]

use any good jquery gallery.
check this : Jquery Lists

Once you download script and demo is working in you pc,
replace static images to dynamic images.

Dynamic images will comes from select query results.