List only last 3 announcements?

[tj]

Hi guys,

Was wondering if anyone could help me modify the following:


<?php
include("support/configuration.php");
include("support/includes/functions.php");
$link = mysql_connect($db_host,$db_username,$db_password);
mysql_select_db($db_name);
$query = "SELECT * FROM tblannouncements WHERE published='on' ORDER BY date DESC";
$result=mysql_query($query);
while($data = mysql_fetch_array($result)) {
$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$announcement = $data["announcement"];
$date = fromMySQLDate($date);
echo("

<font color=#cccccc>$date</font> - $title
$announcement</p>");
}
?>

To only display the last 3 announcements published?

Thanks :)

[Adam]

Hey,

Try the following,


<?php
include("support/configuration.php");
include("support/includes/functions.php");
$link = mysql_connect($db_host,$db_username,$db_password);
mysql_select_db($db_name);
$query = "SELECT * FROM tblannouncements WHERE published='on' ORDER BY date DESC
LIMIT 0, 3";
$result=mysql_query($query);
while($data = mysql_fetch_array($result)) {
$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$announcement = $data["announcement"];
$date = fromMySQLDate($date);
echo("

<font color=#cccccc>$date</font> - $title
$announcement</p>");
}
?>

From,
Adam

[FavHost]

Awsome Adam!

How would i go about changing it to just the last 30 or 60 days?