Database Help

[MrLister]

I need to add screenshots to the site but i bumped into several problems. Per game there may be 1-20 or even more screenshots and on a page such as show.php?id=5 there may be 10 but how can i do this? how can i put all the links inside such as images/diablo001.gif, images/diablo002.gif and so on so it shows it in the page. i need this done through a form where they can just specify (multiple pictures, not one by one) and it will automatically create the links inthe db. pleasee help. i need this really badly.

[Milamber]

Be glad to help you, but I cant for the life of me figure out what you are trying to do...

[freakysid]

Your best bet is to use a database table to store the image name along with the id of the game they belong to:

CREATE TABLE Screenshot (
game INT NOT NULL,
filename VARCHAR(100) NOT NULL
);

To query the database to find the filenames for screenshots that belong to a certain game:

$sql = "SELECT filename FROM Screenshot WHERE game=$id";
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result) {
   echo "<p><img scr=\"$row[0]\">";
} 

That very crude piece of code demonstrates the idea.

[MrLister]

thx for the help. it's greatly appriciate it. just one more hting. how can i do this. when they click on browse to upload a pic that they can select multiple files all at once. and that it stores it inside the screenshot database.

[Kevin Yank]

That isn't possible without writing a custom component for selecting and uploading multiple files. The closest you could hope to come with standard forms would be to select the number of files and then present the user with a form with that many file upload fields.

[MrLister]

oh ok. yeah i was reading through some sites and found out it's not possible, well it is but really hard.