<html>
<table border="0">
<tr>
<td><font face='verdana' color='#00066' size=2><strong>Location</strong></td>
<td><font face='verdana' color='#00066' size=2><strong>Delete</strong></td>
</tr>
<?php
require '../config.php';
$sql = mysql_query("SELECT * FROM location order by location");
while ($res = mysql_fetch_array($sql)) {
$location_id = $res["location_id"];
$location = $res["location"];
print "<tr>\n";
echo " <td><font face='verdana' color='#00066' size=2>$location</td>\n";
echo " <td><font face='verdana' color='#00066' size=2><a href=\"query_del_location.php?location_id=$location_id\">Delete";
print "</tr>\n\n";
}
?>