how would you structure a gallery?

[Sic]

i'm finally giving my website a complete overhaul, and i'm not going to cut any corners on it (well, i'm going to try not to) and the only thing i'm really wondering about how i'm going to do it, is the gallery. i can't decide whether to have it php/mysql, whether xml is going to be the way to go, whether to look at AJAX...i just don't know.

so, HG&P - how would you do it? (or how did you do it!!) as i'm a bit stuck

don't worry, i'm not going to steal anyone's ideas...i'm just going to plagiarise them

 

[robmiller]

PHP/mySQL/GD

Table structure roughly something like:

+--comments--+
| id         |     +----images----+          
| image      | --> | id           |     +----albums----+
| title      |     | album        | --> | id           |
| author     |     | title        |     | name         |
| content    |     | description  |     | description  |
+------------+     | filename     |     +--------------+
                   +--------------+

 

[Sic]

oh cool...that's what i was thinking, and roughly what i have in place already. many thanks