I have three tables.
Picture, Picture Group, and Picture description.

I have picture id, path and date in picture table.

I have Picture grpid, Group in picture group table.

I have Pic_descid and Description in the picture description table.

The question i have is where do i store the pictures? In the picture table i have the location and date. when i write a query for date i have to format the query, i have dummy data for path like c:\saru\img.gif1, 2, and 3.

where would i have the actual pictures.

I am thinking if i had the path in the db and would i have the thumb nails in a file on the web server?

Please help me. Thanks/Saru