where to put images

[explorer]

I am just starting to lurn using access and asp 3.0
and made a connection to the database and can get text
from the database.Now I would like to get pictures in
to my pages but dont where to start.do I upload pictures
to my server using ftp then use a reference to the image's path
in the database rather than using the actual image in the database.
I read that some hosts prohibit the storing of images or blobs within databases,
also I would like to know what blobs means and which option would be best
for me as users to my site could pic an option and the page with say a recordset
of 10 photos would be displayed.any advise greatly received in advance.

thanks for your time

explorer

[WTD]

stick the images in a directory called images, and store the file name in the database. you then create the html to display the images on the fly, using the data pulled out the database.

You can still limit the to 10 photo's by using the LIMIT sql clause to limit it to a number of results.

I find it easier to store images in a directory, and reference them through filenames held in a db (for gallery style sites). No real reason, just personal preference, and a lot quicker to get started on.

Cheers

[explorer]

Thanks for your reply WTD.At the moment
I am reading sql but it only covers select,
insert,update and delete.I will have to have
a look at LIMIT sql clause on the internet as
my ebook does not cover much sql.

thanks

[WTD]

Just put it at the end mate.

select * from images where description like '%exam%' order by date_added desc limit 0, 10

[explorer]

Just put it at the end mate.

select * from images where description like '%exam%' order by date_added desc limit 0, 10

Thanks for your help WTD m8 and the code.

cheers :thumbs