TalkPHP - View Single Post

allworknoplay · 05-22-2009, 09:55 PM

Quote:

Originally Posted by Sirupsen

Cool.

To clear up, this is for a mini-portfolio - so it adds more pictures (the $p1 = picture one url, $p1d = picture one description) - if I choose so from my Admin panel. Which is why I have all the if()'s, so that if those rows are empty, it should not add an empty picture, but just skip that line of code and do NOTHING. :D - but if the row is filled with an url, it should print out the picture to the gallery.

It's in action here.

Sorry if the explanation is messy, just ask if I need to clear something up. :) Cheers

I see, I don't think that is the correct DB structure then.

You are basically creating a unique column for each unique type of picture. You should only have 2 columns.

I mean, if you have 1000 pictures, you can't seriously think about having 1000 columns?

There's a limit for columns for mysql tables that in it itself!