Drop down boxes with php help

@littlenedAug 17.2006 — #Hey, i have a gallery of pictures and i want to sort them by two different drop down boxes. I have a 'Date' drop down box that includes years like 2006,2005 and i have a 'Genre' drop down box that includes Genre's like Comedy, Romance etc.

I know how to sort the pictures by one drop down box but i dont know how to add to it. What i mean is that if i sort it by the year 1999 the address would be .... 'mywebsite.php?year=1999' but now i have sorted it by the year 1999 i would now like to sort it with Genre 'Comedy'

So how can i add the genre 'Comedy' on to the address line... 'mywebsite.php?year=1999' by means of a drop down box?

Many thanks

Matt[/QUOTE]

Basically if you create a form with 2 drop down lists on it, one called year and the other called genre, this will send an url similar to mysite.php?year=1999&genre=comedy

where are you getting the data from? if its from mysql you can use if statements to generate the sql statement depending of the selection by the user.

$year = $_POST['year'];

$genre = $_POST['genre'];

if ($year <> '' AND $genre == '') { $sql = "Select * from Table ORDER BY $year"; }

if ($year == '' AND $genre <> '') { $sql = "Select * from Table ORDER BY .$genre"; }

if ($year <> '' AND $genre <> '') { $sql = "Select * from Table ORDER BY $year,$genre"; }

I might have some of the code wrong there but it should give you an idea.

Drop down boxes with php help

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Drop down boxes with php help

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴