";
include "top.inc";
include "$lib_root/number_cruncher.inc";
$nc=new number_cruncher();
if (!$sort) { $sort="added"; }
if (!$order) { $order="desc"; }
if ($order == "desc") {
$next_order="asc";
} else {
$next_order="desc";
};
echo "
| New |
| Address |
Town |
Agent |
Added |
Price |
Profit |
";
$SQL="select prop_id,address,town,asking_price,rent_est,added,agent,profit,agents.agent_name from properties,agents where properties.agent = agents.agent_id order by $sort $order";
$result = mysql_query($SQL) or die('A error occured: ' . mysql_error());
while ($row_list = mysql_fetch_assoc($result)) {
$row_list[added]=$nc->date_reverse($row_list[added]);
echo "
| $row_list[address] |
$row_list[town] |
$row_list[agent_name] |
$row_list[added] |
$$row_list[asking_price] |
$$row_list[profit] |
";
}
echo "
";
include "bottom.inc";
?>