[php]
$connection = mysql_connect(‘localhost’, ‘baloogan_cdb’, ‘cdbcdbcdbcdb’);
mysql_select_db(‘baloogan_db3000’);
$query = “SELECT ID,Name,YearCommissioned FROM DataAircraft ORDER BY Name , YearCommissioned “; //You don’t need a ; like you do in SQL
$result = mysql_query($query);
echo “[table]”;
echo “[tr][td][strong]ID[/strong][/td][td][strong]Name[/strong][/td][td][strong]Year[/strong][/td][/tr]”;
while($row = mysql_fetch_array($result)){
$start = “<a href=’http://wiki.baloogancampaign.com/index.php/DataAircraft?ID=” . $row[‘ID’] . “‘>”;
$end = “</a>”;
echo “[tr][td]” . $row[‘ID’] . “[/td][td]” .$start. $row[‘Name’] .$end. “[/td][td]” . $row[‘YearCommissioned’] . “[/td][/tr]”;
}
echo “[/table]”;
mysql_close();
[/php]
