[php]
$connection = mysql_connect(‘localhost’, ‘baloogan_cdb’, ‘cdbcdbcdbcdb’);
mysql_select_db(‘baloogan_db3000’);
$query = “SELECT ID,Name,YearCommissioned FROM DataSubmarine 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)){
echo “[tr][td]” . $row[‘ID’] . “[/td][td]” . $row[‘Name’] . “[/td][td]” . $row[‘YearCommissioned’] . “[/td][/tr]”;
}
echo “[/table]”;
mysql_close();
[/php]
