include("../connect.php"); ?>
if($_GET["rendez"]){}else{ echo '
Rendezés
';} ?>
>Cím Szerint
>Dátum Szerint
>Megtekintés Szerint
if($_GET["rendez"]){ $rendez=$_GET["rendez"]; } else { $rendez="datum"; } $fb=""; $hit=""; if($_GET["cat"]){ $res=mysql_query("SELECT * from videoportal_vid WHERE vidcat = '".$_GET["cat"]."' ORDER BY ".$rendez." DESC LIMIT 20"); $row = mysql_fetch_assoc($res); $fb="?fb=".$row['vidid'].""; $hit="?hit=".$row['vidid'].""; $res=mysql_query("SELECT * from videoportal_vid WHERE vidcat = '".$_GET["cat"]."' ORDER BY ".$rendez." DESC LIMIT 20"); while($data=mysql_fetch_array($res)){ echo '
'; } } if(!$_GET["cat"] && !$_GET["keres"] && !$_GET["id"]){ $res=mysql_query("SELECT * from videoportal_vid ORDER BY ".$rendez." DESC LIMIT 20"); $row = mysql_fetch_assoc($res); $fb="?fb=".$row['vidid'].""; $hit="?hit=".$row['vidid'].""; $res=mysql_query("SELECT * from videoportal_vid ORDER BY ".$rendez." DESC LIMIT 20"); while($data=mysql_fetch_array($res)){ echo '
'; } } if($_GET["keres"]){ $keres=mysql_query("SELECT * FROM videoportal_vid WHERE vidcim COLLATE UTF8_GENERAL_CI LIKE '%".$_GET["keres"]."%' AND vidcat = '".$_GET["category"]."' ORDER BY ".$rendez." DESC"); $row = mysql_fetch_assoc($keres); $fb="?fb=".$row['vidid'].""; $hit="?hit=".$row['vidid'].""; $keres=mysql_query("SELECT * FROM videoportal_vid WHERE vidcim COLLATE UTF8_GENERAL_CI LIKE '%".$_GET["keres"]."%' AND vidcat = '".$_GET["category"]."' ORDER BY ".$rendez." DESC"); while($data=mysql_fetch_array($keres)){ echo '
'; } } if($_GET["id"]){ $fb="?fb=".$_GET["id"].""; $hit="?hit=".$_GET["id"].""; $res=mysql_query("SELECT * from videoportal_vid WHERE vidid = '".$_GET["id"]."' LIMIT 1"); while($data=mysql_fetch_array($res)){ echo '
'; } } ?>