Im having trouble with this script. I need to limit it to only display the 8 most recent entries into the database. I know i need to put the LIMIT clause on my SELECT statement, but i dont know how to use it. can someone help me out.
<?
$db_name = "da_name";
$table_name = "db_table";
$connection = @mysql_connect("localhost", "user", "pass") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
$sql = "SELECT poster, subject, email, news, date, id FROM $table_name ORDER BY id DESC LIMIT 8";
$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
$subject = $row['subject'];
$news = $row['news'];
$email = $row['email'];
$date = $row['date'];
$poster = $row['poster'];
}
$display_block = "
// HTML to Display News
";
?>
<?
$db_name = "da_name";
$table_name = "db_table";
$connection = @mysql_connect("localhost", "user", "pass") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
$sql = "SELECT poster, subject, email, news, date, id FROM $table_name ORDER BY id DESC LIMIT 8";
$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
$subject = $row['subject'];
$news = $row['news'];
$email = $row['email'];
$date = $row['date'];
$poster = $row['poster'];
}
$display_block = "
// HTML to Display News
";
?>