Shuan,
Probably best to just store the url
(ie.
http://domain-name.comm/images/i1.jpg)
within your MySQL database then use PHP to create the image tag in
HTML.
It could be argued that by already accessing the database one should
pull the actual image from the same source but that would be dependant
upon the size of the image and the number of images being pulled from
the database.... ...if the images are large or many the end user could
experience a delay in the initial display of the page (especially on a
shared/busy server). No delay (or at least would not be hampered by
large data retrieval) would occur if only the url was stored within
the database.
Dave Walker
For PHP and MySQL demo try here:
http://www.thedemosite.co.uk -- hey its free.
Seiretto for Hosting Solutions that Work.
http://www.Seiretto.com
On Fri, 12 Sep 2003 10:32:18 +0100, "Shaun Campbell"
<shaun.campbell@virgin.net> wrote:
[color=blue]
>I know you're going to say search the mail archives, but I have and I can't
>find an answer to my simple question of is there an SQL statement to load an
>image in a .jpg file into a database table?
>
>Also, I have read in lots of places that it's probably not a good idea to
>store images in mysql but just store a pointer to the file. Is this the
>accepted way of doing things with mysql?
>
>Thanks
>
>Shaun
>
>[/color]
Dave Walker
For PHP and MySQL demo try here:
http://www.thedemosite.co.uk -- hey its free.
Seiretto for Hosting Solutions that Work.
http://www.Seiretto.com 
