If statements with MySQL?

[mmarif4u]

Can you post your updated code.

[Nymphetamine]

<?php
$result = mysql_query("SELECT * FROM ###########");
while($row = mysql_fetch_assoc($result)){
echo "<td>";

if ($row['date'] == '0501' && $row['property'] == '1') {
echo "$row[name]";
}
else {
echo "Empty";
}
        echo "</td><td>";

if ($row['date'] == '1201' && $row['property'] == '1') {
echo "$row[name]";
}
else {
echo "Empty";
}

        echo "</td><td>";

if ($row['date'] == '1901' && $row['property'] == '1') {
echo "$row[name]";
}
else {
echo "Empty";
}

        echo "</td>";

}
?>