mysq_hell

Hi Im Pretty New Myself, But Basically you dont need three pages you just need one and then all you need to do is filter the results with a recordset and URL Parameter.. So you`ll Just have a results page that shows just one secter based upon the link or form the user submits... Example link results.php?sectorID=shooting Paul.

Hi, Managed to Solve Problem One... Added Static menu item and Blanked out the Select value equal to Box.. Can anyone help with the SQL for problem 2, The Static Menu Options have a value of 0, Which Means if the Form is Submitted without Changing the Default value Nothing Happens... Paul.

Hi, Im in the middle of writing an online catalogue for my Company and as an Exercise for me to learn More about PHP and Mysql etc.. All is working fine but i need a few Pointers if anyone can help.. 1st Problem.. When my Form loads with the Dynamic Content it always shows tthe last record? I understand this is Normal, But from From all the Websites ive ever visted, ive never once seen this put into Practice? Most have a "please Choose" or a Name for the pull Down menu ie a Sports Site might have "Trainers" and then when you access the menu you see the trainers you can Choose? 2nd problem.. I have 2 Pull Down menus and 1 Submit button that Filters out the results from the Menus, Works Lovely, But it would be handy if you could Choose just One of the pull down menus and the 2nd one displayed all of the results from that Category.. let me give you an Example :- Pull Down Menu 1 is Trainers Pull Down menu 2 is Colour Right now you can Choose Nike and White from the Menus and press Submit and you see all White Nike trainers.. But what if i wanted to list all Nike Trainers? how can i Add an All Category to the Colour Menu? and Vise Versa? Im Still Pretty New to PHP but have a Fairly Good Understanding as ive got this Far... Thanks for Reading... Hope it made Sense... Paul.