Ik heb een probleempje in PHP, icm MySQL.
Namelijk dit:
<?php
$query = "SELECT * FROM liveacars WHERE idpilot = `" . $id . "`";
$sqlquery = mysql_query($query, $con);
while ($rows = mysql_fetch_array($sqlquery)) {
imagestring($img, 3, 200, 50, $rows['FullName'] . " (" . $rows['IDPilot'] . ")", $color["White"]);
imagestring($img, 3, 200, 60, $rows['OriginAirport'] . " => " . $rows['DestinationAirport'], $color["White"]);
$status = "NONE";
switch ($rows['Status']) {
case 0:
$status = "Boarding";
break;
case 1:
$status = "Departing";
break;
case 2:
if ($rows['Altitude'] < 2000) {
$status = "Airborne";
break;
} elseif ($rows['Altitude'] > 2000) {
$status = "Climbing";
break;
} elseif ($rows['AltitudeStatus'] == 1) {
$status = "Cruising";
break;
} elseif ($rows['AltitudeStatus'] == 0) {
$status = "Descending";
break;
} elseif ($rows['Altitude'] < 10.000) {
$status = "Initial Approach";
break;
} elseif ($rows['Altitude'] < 2.500) {
$status = "Final Approach";
break;
}
break;
case 3:
$status = "Landed";
break;
case 4:
$status = "On Blocks";
break;
}
$eta = $rows['DistancePlanned'] - $rows['DistanceFlown'] / $rows['IAS'];
imagestring($img, 3, 200, 70, "Status: " . $status, $color["White"]);
imagestring($img, 3, 200, 80, "A/C Type: " . $rows['Aircraft'] . " / ZFW: " . $rows['ZFW'] . " kg's", $color["White"]);
imagestring($img, 3, 10, 125, "ALT: " . $rows['Altitude'] . " - SPD: " . $rows['IAS'] . " - ETA: " . $eta, $color["White"]);
}
?>
En bij While krijg ik de melding;
Parse error: syntax error, unexpected T_WHILE in /home/a6283833/public_html/members/sig/acars.php on line 31 (in dit geval lijn 5)
De script, boven de, in deze post zittende code, heb ik weggedaan.
Maar ook een klein stukje, onderkant.
Ik hoop dat iemand me kan helpen?!.
Alvast bedankt!.
Groet,
Brian