Flight:
Based on the following location:
$zoekDatum= $_GET['zoekstring'];
$zoekHex= $_GET['Hex'];
$Bewaartijd='';
$link = mysql_connect("localhost", "LiveModeS", "LiveModeS");
mysql_select_db("modes", $link);
$query2 = mysql_query("Select Location, GMT FROM livegmt where (HexId='$zoekHex' and Date='$zoekDatum') ORDER BY livegmt.GMT asc" );
while ($row = mysql_fetch_assoc($query2))
{
$CSLocation =$row["Location"];
$CSTime =$row["GMT"];
if ($Bewaartijd=='')
{
$Bewaartijd=$CSTime;
}
if ($Bewaartijd<= $CSTime)
{
$query3=mysql_query("SELECT ADDTIME('$CSTime', '0 0:20:0' )") ;
while ($row1 = mysql_fetch_assoc($query3))
{
$CSTijd= $row1["ADDTIME('$CSTime', '0 0:20:0' )"];
$CSTijd= substr($CSTijd,0,19) ;
$Bewaartijd=$CSTijd;
}
echo "";
echo "";
}
}
echo "";
?>
include("save/database.php");
$url=$_SERVER['PHP_SELF'];
$AantalInsert="INSERT INTO hits(Page,Aantal) VALUES('$url',1)
ON DUPLICATE KEY UPDATE Aantal=Aantal+1";
//echo $AantalInsert;
$query666 = mysql_query($AantalInsert);
if (!$query666)
{
//die('invalid TEST'. mysql_error());
}
$SELECTAantal="SELECT Aantal FROM hits where Page='$url'";
$result = mysql_query($SELECTAantal);
$row = mysql_fetch_array($result, MYSQL_NUM);
$count = $row[0];
echo "
";
echo "
";
echo "";
echo "";
echo $count;
echo "
";
echo "";
echo "
";
echo "
";
?>