[AlexGM14]

hi im building a gaming website and i have this link thats titled: "PS2" and when you click on it i want all the game titles i have in my database to appear in the combo box. then when i they hilite the game they r looking for, i want a submit button for them to click on that takes them to the info part of the game.

so in my database would i need 3 columns..id, title, and info?

and once i make the database how do i set the combo box code up, plz point me in the right direction.

[blaw]

Hello,

1) Pass a parameter like 'ps2' via URL when "PS2" is clicked. By parameter, I mean something like this:

Code:

<a href="foo.php?c=ps2">PS2</a>

2) Based on what parameter you have passed, query the database (i.e. get all the titles for 'ps2').

3) Create a form and <select> tags, as well as a submit button that will pass another parameter. For instance, if a user has chosen "Final Fantasy 9", then 'ff9', along with the 'ps2', etc. Then get a detail page based on these parameters.

4) As for the database, it depends on what you want to show, but using 'ff9' as an ID (PK), "Final Fantasy 9" as Title, and whatever the contents you want to show as Info seems okay, if all you want to show can/should be stored in one field Info.

5) As for creating the <option> tags within the <select> tags, you can loop the query result.

Sorry I'm not too detailed, but this is the approach I would take, more or less. Hope this gives you some idea.