PS, for the heck of it. say

Greg K — Sun, 19 Jul 2009 04:01:10 +0000

PS, for the heck of it. say you need a list of all items AND the image from the FIRST file uploaded with it (the primary image), and assuming you don't need AltText as the ItemTitle will work for that in a listing of items. You can use the following. I have it broken up across lines for easier reading here.

SELECT 
  i.*, 
  (SELECT 
     f.`Thumb` 
   FROM 
     `tblFiles` AS f 
   WHERE 
     f.`ItemID`=i.`ID` 
   ORDER BY `Order` 
   LIMIT 1
  ) AS Thumb 
FROM 
  `tblItems` AS i

Now you will have all the item fields plus "Thumb"

-Greg

Basically, you will have a

Greg K — Sun, 19 Jul 2009 03:55:03 +0000

Basically, you will have a table with the content (what you are used to doing with the title,price, etc):

tblItems
========
ID auto-incrementing integer as primary key
Title
Description
Price
Other

Now you will have a table to hold the information about the files.

tblFiles
========
ID auto-incrementing integer as primary key
ItemID The tblItems.ID (foreign key) of the item this image goes with
Order and integer to sort by for ordering the images (if you code that)
FileName The name of a file that is uploaded to a media directory
AltText The AltText for the image / caption
ThumbName A resized copy for use as thumbnails (see http://www.imagemagick.org/script/convert.php)

Now when you load up the item data, then do a second query to get the image information that goes with it.

-Greg

can you post the url where

scriptbazaar — Sat, 18 Jul 2009 14:29:46 +0000

can you post the url where your script is currently running ?