Simplifying a Query

[thekidscareya]

Is it possible to simplify this query to 1 query to save system resources?

<?php
	$president_sql = "SELECT * FROM `tbl_officers` WHERE `year` = '".$year."' AND `position` = 'President' LIMIT 1";
	$president_query = mysql_query($president_sql) or die(mysql_error());
	$president_row = mysql_fetch_array($president_query);
	echo "President - $president_row['name'] <br>";

$vice_president_sql = "SELECT * FROM `tbl_officers` WHERE `year` = '".$year."' AND `position` = 'Vice President' LIMIT 1";
$vice_president_query = mysql_query($vice_president_sql) or die(mysql_error());
$vice_president_row = mysql_fetch_array($vice_president_query);
echo "Vice President - $vice_president_row['name'] <br>";

$secratary_sql = "SELECT * FROM `tbl_officers` WHERE `year` = '".$year."' AND `position` = 'Secratary' LIMIT 1";
$secratary_query = mysql_query($secratary_sql) or die(mysql_error());
$secratary_row = mysql_fetch_array($secratary_query);
echo "Secratary - $secratary_row['name'] <br>";	

$treasurer_sql = "SELECT * FROM `tbl_officers` WHERE `year` = '".$year."' AND `position` = 'Treasurer' LIMIT 1";
$treasurer_query = mysql_query($treasurer_sql) or die(mysql_error());
$treasurer_row = mysql_fetch_array($treasurer_query);
echo "Treasurer - $treasurer_row['name'] <br>";	

?>

I want the president of the given year, $year, to be listed first, then the vice president, so on and so forth. How do I do this in SQL? If not, is there a way I can do this in PHP?

Thanks.

[devinemke]

$result = mysql_query("SELECT * FROM tbl_officers WHERE year = '$year'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['name'] . ' = ' . $row['position'] . '<br>';
}

[thekidscareya]

That would work, but the problem is that it is sorted by the primary key. The data isn't all in perfect order in the database.

[devinemke]

$order = array('President', 'Vice President', 'Secratary', 'Treasurer');

$result = mysql_query("SELECT * FROM tbl_officers WHERE year = '$year'") or exit(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) {$officers[$row['position']] = $row['name'];}
foreach ($order as $value) {echo $value . ' ' . $officers[$value] . '<br>';}

[thekidscareya]

Thanks...that did it.