$sql="SELECT date_format(lotto_date,\"%d %M %Y\") as lottoDate,
num_1,num_2,num_3,num_4,winner,runner_up1,runner_up2,prize_money
FROM t_lotto order by lotto_date DESC limit 1";
$result = mysql_query($sql);
if (!$result) {
echo("Error performing query: " . mysql_error() . " ");
exit();
}
$numrows=mysql_num_rows($result);
if ($numrows == 0) {
?>
| |
No lotto results available |
}
else {
$row = mysql_fetch_array($result);
$lotto_date = $row["lottoDate"];
$num_1 = " ";
$num_2 = " ";
$num_3 = " ";
$num_4 = " ";
$winner = $row["winner"];
$runner_up1 = $row["runner_up1"];
$runner_up2 = $row["runner_up2"];
$prize_money = $row["prize_money"];
?>
|