Forums
This topic is locked
pls help for mysql dremwaver8
Posted 08 Apr 2007 20:32:54
1
has voted
08 Apr 2007 20:32:54 khairy khairy posted:
how i can display image (jpg file ) from msql data base using recordset in dremwaver ?i try using
photo as ( blob ) in mysql
whine using recordset to display it is come (like bad text)
sory for my english
thankis
for all
Replies
Replied 10 Apr 2007 15:29:58
10 Apr 2007 15:29:58 rob hewitt replied:
I have a similar setup on my site, the images are stored in a folder such as www.mysite.com/images
your MySQL table will have a field for the image details, called image or whatever you want. Enter the full address of the image in this field i.e. www.mysite.com/images/image1.jpg
In dreamweaver, create your recordset however you want it & where you want the dynamic image to appear, select insert image & in the new window that will appear, select dynamic source & choose the recordset you created & the field you have stored the path to the image.
You'll now have a dynamic image on your page that will point to the image stored on your website.
your MySQL table will have a field for the image details, called image or whatever you want. Enter the full address of the image in this field i.e. www.mysite.com/images/image1.jpg
In dreamweaver, create your recordset however you want it & where you want the dynamic image to appear, select insert image & in the new window that will appear, select dynamic source & choose the recordset you created & the field you have stored the path to the image.
You'll now have a dynamic image on your page that will point to the image stored on your website.