# total flight time / block time
$query = "SELECT sec_to_time(sum(time_to_sec(TotalBlockTime))) FROM flights ".$condition;
$result=mysql_query($query);
$TFT = number_format(mysql_result($result,0));$query = "SELECT PilotName, COUNT(PilotName) as TnF, SEC_TO_TIME(SUM(TIME_TO_SEC(TotalBlockTime))) AS TTotalBlockTime, SUM(NbrPassengers) AS TNbrPassengers, SUM(BonusPoints) AS TBonusPoints, SUM(PenalityPoints) AS TPenalityPoints, SUM(BonusPoints - PenalityPoints) AS TotalPoint FROM flights GROUP BY PilotName ORDER BY $sortColumn LIMIT $pStart,$pageLines";
if(!$result=mysql_query($query))
{
echo "SQL Error - ".mysql_error()."<br>".$query;
return;
}
Passwortverschlüsselung mysql bzw php
schojo 05.04.2008 - 73 Hits - 7 Antworten
Abfrage in PHP/MySQL
ClaudiaGauss 15.07.2008 - 45 Hits - 2 Antworten
PHP-MySQL Fehler
detommy 01.12.2008 - 29 Hits - 3 Antworten
php/mysql Datenbankzugriff schützen
dasbinichich 17.06.2009 - 333 Hits - 3 Antworten
OpenSource Browsergame in PHP und MySQL
TByte 04.08.2009 - 1031 Hits - 5 Antworten