[!--quoteo(post=352937:date=Mar 8 2006, 07:09 PM:name=anticore)--][div class=\'quotetop\']QUOTE(anticore @ Mar 8 2006, 07:09 PM) [snapback]352937[/snapback][/div][div class=\'quotemain\'][!--quotec--] i'm trying to create a simple gallery for my site. and i'm not sure on how to go about it. i'm designing my mysql table to look like id,name,year,yearsection,description,image1,image2,image3,image4,thumbnail yearsection is so that i can call all the images within year catagories i have already defined and the imageX are to store the locations of the images. i'm thinking i'm going to need a couple functions a listing function to list according to my year catagories showing a thumbnail and just a name a id function to load whatever image/name is chosen on the listing page with the describtion and images and an add/delete/modify. Is there something i'm forgetting? or is there a better way of doing this [/quote] Maybe it's the complicated part of me, but I would definately seperate this into at least a few tables and join them based on the data you need. What are the image1-4 for? wouldn't it just be 1 source image, grouped together by category, year, event? something along those lines? I think you have a good general idea, but it needs to be expanded a little bit ;)