Hi everybody,
I’m rather new to PHP, so forgive my ignorance.
I’m trying to make movie catalog. I made a drop down list containing movie genres, and if one selects one genre it would filter database and show chosen genre. It all works perfectly. except I want add one more option to drop down list called /all/ and I want it when selected from drop down list to show all records. And I dont know how to do it. please give some idea.
here’s the code:
[code]
Prika?i samo :
ALL
akcije
crtiće
avanturističke
bajke
borilacke
dokumentarce
drame
ex yu
horore
James bondove
komedije
manga crtiće
muzicke
ratne
romanse
scifi
spektakle
westerne
zatvorske
<table>
<tr bgcolor="#CCCCCC">
<?php
echo "<th class='top' width='4%'><a href='DVDkat.php?sort=tbl_filmovi_rb&order=$orderin'>Rb</a></td>";
echo "<th class='top' width='35%'><a href='DVDkat.php?sort=tbl_filmovi_imefilma&order=$orderin'>NASLOV</a></td>";
echo "<th class='top' width='7%'><a href='DVDkat.php?sort=tbl_filmovi_regija&order=$orderin'>REGIJA</a></td>";
echo "<th class='top' width='3%'><a href='DVDkat.php?sort=tbl_filmovi_medij&order=$orderin'>MEDIJ</a></td>";
echo "<th class='top' width='10%'><a href='DVDkat.php?sort=tbl_filmovi_zanr&order=$orderin'>ZANR</a></td>";
echo "<th class='top' width='7%'><a href='DVDkat.php?sort=tbl_filmovi_lokacija&order=$orderin'>LOKACIJA</a></td>";
echo "<th class='top' width='10%'><a href='DVDkat.php?sort=tbl_filmovi_rezija&order=$orderin'>REZIJA</a></td>";
echo "<th class='top' width='24%'><a href='DVDkat.php?sort=tbl_filmovi_glumi&order=$orderin'>GLUMI</a></td>";
?>
<?php
$upitzanr = $_POST['tbl_filmovi_zanr'];
if (isset($_POST['tbl_filmovi_zanr'])) {
mysql_select_db($db, $link);
$query = "SELECT * FROM tbl_filmovi WHERE tbl_filmovi_zanr = '$upitzanr' ORDER BY tbl_filmovi_imefilma ASC";}
else if ($_POST['tbl_filmovi_zanr'] = 'all') {
$query = "SELECT * FROM tbl_filmovi ORDER BY tbl_filmovi_rb DESC";}
else {$query = "SELECT * FROM tbl_filmovi ORDER BY tbl_filmovi_rb DESC";}
$result = mysql_query($query) or die("Query failed: " . mysql_error());
while ($row=mysql_fetch_array($result))
{
$id = $row['tbl_filmovi_rb'];
$loc = $row['tbl_filmovi_lokacija'];
$reg = $row['tbl_filmovi_regija'];
$name = $row['tbl_filmovi_imefilma'];
$zanr = $row['tbl_filmovi_zanr'];
$med = $row['tbl_filmovi_medij'];
$rez = $row['tbl_filmovi_rezija'];
$glum = $row['tbl_filmovi_glumi'];
}
mysql_select_db($db, $link);
$result = mysql_query($query, $link);
if(mysql_num_rows($result)) {
$rank = 1;
while($row = mysql_fetch_row($result))
{
print("</tr><tr>");
if($color == "#D8DBFE") {
$color = "#a9bac3";
} else {
$color = "#D8DBFE";
}
print("<td width="4%" bgcolor="$color">$row[0]</td>");
print("<td width="35%" bgcolor="$color"><strong><a href='DVDedit.php?id=$row[0]'>$row[1]</a></strong></td>");
print("<td width="7%" bgcolor="$color">$row[2]</td>");
print("<td width="3%" bgcolor="$color">$row[3]</td>");
print("<td width="10%" bgcolor="$color">$row[4]</td>");
print("<td width="7%" bgcolor="$color">$row[5]</td>");
print("<td width="10%" bgcolor="$color">$row[6]</td>");
print("<td width="24%" bgcolor="$color">$row[7]</td>");
$rank++;
}
}
?>
</table>[/code]