<?php
//
// iLink - SELECT i ORDER v7
//
	// po vremenu promena unazad
	if ($t_sel=="GST") {
		$sql = "SELECT * FROM $dbt ORDER BY dt DESC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	//
	if ($t_sel=="USR") {
		$sql = "SELECT * FROM $dbt ORDER BY dt DESC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	//
	if ($t_sel=="ADM") {
		$sql = "SELECT * FROM $dbt ORDER BY dt DESC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
    //
	// po ID
	if (($t_sel=="Sel_1")and($t_txt=='')) {
		$sql = "SELECT * FROM $dbt ORDER BY id ASC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	if (($t_sel=="Sel_1")and($t_txt!='')) { 
		$sql = "SELECT * FROM $dbt WHERE id='".$t_txt."'";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
    //	
	// po vremenu promena unazad
	if ($t_sel=="Sel_2") {
		$sql = "SELECT * FROM $dbt ORDER BY dt DESC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	//
	// po popularnosti glasanja vot
	if (($t_sel=="Sel_3")and($t_txt=='')) {
		$sql = "SELECT * FROM $dbt ORDER BY vot DESC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	if (($t_sel=="Sel_3")and($t_txt!='')) {
	    $sql = "SELECT * FROM $dbt WHERE vot='".$t_txt."'";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}	
	//
	// po opstoj temi
	if (($t_sel=="Sel_4")and($t_txt=='')) {
		$sql = "SELECT * FROM $dbt ORDER BY notes ASC, notem ASC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	if (($t_sel=="Sel_4")and($t_txt!='')) {
		$sql = "SELECT * FROM $dbt WHERE notes LIKE '%".$t_txt."%' ORDER BY notem ASC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);	
	}
	//
	// po autoru
	if (($t_sel=="Sel_5")and($t_txt=='')) {
		$sql = "SELECT * FROM $dbt ORDER BY notem ASC, vot DESC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	if (($t_sel=="Sel_5")and($t_txt!='')) {	
		$sql = "SELECT * FROM $dbt WHERE notem LIKE '%".$t_txt."%' ORDER BY vot DESC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
    //
	// po kompoziciji
	if (($t_sel=="Sel_6")and($t_txt=='')) {
		$sql = "SELECT * FROM $dbt ORDER BY notel ASC";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	if (($t_sel=="Sel_6")and($t_txt!='')) {
		$sql = "SELECT * FROM $dbt WHERE notel LIKE '%".$t_txt."%'";
		$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
		$numofrows = mysqli_num_rows($result);
	}
	//
	mysqli_close($conn);
	
?>