$con = mysql_connect("duncaninnes.netfirmsmysql.com","duncanuser","soldones");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db(duncanrules, $con);
$result = mysql_query("SELECT * FROM soldproperty WHERE active=1");
echo '
';
while($row = mysql_fetch_array($result))
{
echo "";
echo "SOLD ";
echo $row['date'];
// end of sold column, start of picture column that spans 2 rows, then end of picture column
echo " | | ";
// start of title row
echo "";
echo $row['title'];
// end of title row
echo " |
";
echo $row['description'];
echo " |
";
}
echo '
';
mysql_close($con);
?>