Problems with SELECT and IF

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]

i’d use an empty value for all:

all

check tbl_filmovi_zanr for being empty and use just an else:
[php] if (isset($_POST[‘tbl_filmovi_zanr’]) && !empty($_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 {
$query = “SELECT * FROM tbl_filmovi ORDER BY tbl_filmovi_rb DESC”;}[/php]

Heh! Simple as that :) Thank you very much, it works just as I intended.

Sponsor our Newsletter | Privacy Policy | Terms of Service