$mainfilter=$_GET['filter'];
$maintrip=$_GET['trip'];
include("dbinfo.inc.php");
mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
if ($mainfilter=="" or $mainfilter=="All" and $trip==""){
$query="SELECT * FROM traveling order by filter, trip, orden";
$row=1;
//echo "No filter";
}else if ($mainfilter!="" and $mainfilter!="All" and $trip==""){
$query="SELECT * FROM traveling where filter = '".$mainfilter."' order by filter, trip, orden";
$query2="SELECT orden FROM traveling where filter = '".$mainfilter."' order by filter, trip, orden DESC limit 1";
$query3="SELECT distinct trip FROM traveling where filter = '".$mainfilter."' order by trip";
$result2 = mysql_query($query2);
$result3 = mysql_query($query3);
$array = mysql_fetch_array($result2);
$row=max($array)+1;
$num3=mysql_numrows($result3);
//echo "Filtering on ".$mainfilter;
}else if ($mainfilter!="" and $trip!=""){
$query="SELECT * FROM traveling where filter='".$mainfilter."' and trip='".$maintrip."' order by filter, trip, orden";
$query2="SELECT orden FROM traveling where filter = '".$mainfilter."' and trip='".$maintrip."' order by filter, trip, orden DESC limit 1";
$query3="SELECT distinct trip FROM traveling where filter = '".$mainfilter."' order by trip";
$query4="SELECT * FROM traveling where filter = '".$mainfilter."' and trip='".$maintrip."'";
$result2 = mysql_query($query2);
$result3 = mysql_query($query3);
$result4 = mysql_query($query4);
$array = mysql_fetch_array($result2);
$row=max($array)+1;
$num3=mysql_numrows($result3);
$foundtrip=mysql_result($result4,0,"trip");
$foundcode=mysql_result($result4,0,"code");
//echo "Filtering on ".$mainfilter." and on trip ".$trip."";
}
$result=mysql_query($query);
$num=mysql_numrows($result);
$query = "SELECT distinct filter FROM traveling order by filter";
$result1 = mysql_query($query);
$num1=mysql_numrows($result1);
mysql_close();
?>