[SOLVED] Limiting output of database list with IF statement?

[Anticrombie]

Hey guys, I appreciate any help you can give. I'm new to php-MS SQL.

 

CURRENT STATUS: I have a page that pulls from a database and displays a full list. It is a database of movies, and the db holds info on the name, director, category, etc.

 

FINAL OUTPUT: I want the page to only display items that also have a particular category.

 

EXAMPLE: I want the user to be able to see only films in the 'animated' category.

 

Here is the current code to pull the info:

 

<?php
switch($view){
	case 'day':
		$date=strtotime($_GET['date']);
		$date_str="schedule_".strtolower(date("F_j_y_D",$date)).".php";
		include $date_str;
		break;

	case 'cat':
		if(connect()){
			global $conn;
			$exec=mssql_query($sql[$cat]['sql'],$conn);
			echo "<table border=0 cellpadding=0 cellspacing=0 class='movie_list'>";
			if(mssql_num_rows($exec)>0){
				echo "\n<tr>\n\t<td colspan='2' class='searchTitle'>";
				echo $sql[$cat]['display'];
				echo "\n\t</td>\n</tr>";
				while($result=mssql_fetch_array($exec)){
					echo "\n<tr>\n\t<td class='movieName'>\n\t\t";
					//echo "<a href=\"javascript:launchwin('schedule/details_film08.php?ID=".$result['FilmID']."', 'ch2', 'scrollbars=yes,width=500,height=525,left=45,top=25,screenX=45,screenY=25','mainwindow');\">".$result['Film_Title']."</a>";
					echo "<a href='schedule/details_film08.php?ID=".$result['FilmID']."&bw=575&bh=500' class='jcebox' style='text-decoration:none' title='".$result['Film_Title']."'>".$result['Film_Title']."</a>";
					echo "\n\t</td><td class='directorName'>";
					echo $result['Category'];
					echo "\n\t</td>";
					echo "\n</tr>";
				}
			}else{
				echo "<tr><td colspan>";
				echo "Your search returned no results.";
				echo "</td></tr>";
			}
			echo "\n</table>";
		}
}
?>

 

In the database, I have two options for category:

[CatNum] - which displays a category number

[Category] - which is the category name I want to display by. For instance, a category would be 'animated', and I want to show the list of only the animated movies.

 

Any help at all is appreciated (I really don't know what I'm doing )

[Anticrombie]

Got it...

 

I just added an IF wrapper in the middle of the function, instead of trying to limit the function before it runs. A bit neanderthal in that it probably runs clunky, but serves it's purpose.

 

I changed:

if(mssql_num_rows($exec)>0){
				echo "\n<tr>\n\t<td colspan='2' class='searchTitle'>";
				echo $sql[$cat]['display'];
				echo "\n\t</td>\n</tr>";
				while($result=mssql_fetch_array($exec)){
						echo "\n<tr>\n\t<td class='movieName'>\n\t\t";
						//echo "<a href=\"javascript:launchwin('schedule/details_film08.php?ID=".$result['FilmID']."', 'ch2', 'scrollbars=yes,width=500,height=525,left=45,top=25,screenX=45,screenY=25','mainwindow');\">".$result['Film_Title']."</a>";
						echo "<a href='schedule/details_film08.php?ID=".$result['FilmID']."&bw=575&bh=500' class='jcebox' style='text-decoration:none' title='".$result['Film_Title']."'>".$result['Film_Title']."</a>";
						echo "\n\t</td><td class='directorName'>";
						echo $result['FirstNm']." ".$result['LastNm'];
						echo "\n\t</td>";
						echo "\n</tr>";
				}

 

To

if(mssql_num_rows($exec)>0){
				echo "\n<tr>\n\t<td colspan='2' class='searchTitle'>";
				echo $sql[$cat]['display'];
				echo "\n\t</td>\n</tr>";
				while($result=mssql_fetch_array($exec)){
					if ($result['CatNum']=='1'){
						echo "\n<tr>\n\t<td class='movieName'>\n\t\t";
						//echo "<a href=\"javascript:launchwin('schedule/details_film08.php?ID=".$result['FilmID']."', 'ch2', 'scrollbars=yes,width=500,height=525,left=45,top=25,screenX=45,screenY=25','mainwindow');\">".$result['Film_Title']."</a>";
						echo "<a href='schedule/details_film08.php?ID=".$result['FilmID']."&bw=575&bh=500' class='jcebox' style='text-decoration:none' title='".$result['Film_Title']."'>".$result['Film_Title']."</a>";
						echo "\n\t</td><td class='directorName'>";
						echo $result['FirstNm']." ".$result['LastNm'];
						echo "\n\t</td>";
						echo "\n</tr>";
				}
				}

 

 

Basically wrapping the function in:

if ($result['CatNum']=='1'){ FUNCTION HERE }

 

Thanks again for everyone browsing my question, I know it's tough to figure out someone else's code sometimes.