Forum Moderators: coopster
Please suggest How to display random titles from last latest 10 records?.
Here is my code to generate 10 latest records from mysql.
<?php require_once('Connections/Rss.php');?>
<?php
$maxRows_rsnews = 10;
$pageNum_rsnews = 0;
if (isset($_GET['pageNum_rsnews'])) {
$pageNum_rsnews = $_GET['pageNum_rsnews'];
}
$startRow_rsnews = $pageNum_rsnews * $maxRows_rsnews;
mysql_select_db($database_Rss, $Rss);
$query_rsnews = "SELECT Title FROM content ORDER BY `timestamp` DESC";
$query_limit_rsnews = sprintf("%s LIMIT %d, %d", $query_rsnews, $startRow_rsnews, $maxRows_rsnews);
$rsnews = mysql_query($query_limit_rsnews, $Rss) or die(mysql_error());
$row_rsnews = mysql_fetch_assoc($rsnews);
if (isset($_GET['totalRows_rsnews'])) {
$totalRows_rsnews = $_GET['totalRows_rsnews'];
} else {
$all_rsnews = mysql_query($query_rsnews);
$totalRows_rsnews = mysql_num_rows($all_rsnews);
}
$totalPages_rsnews = ceil($totalRows_rsnews/$maxRows_rsnews)-1;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Random</title>
</head>
<body>
<table border="0">
<?php do {?>
<tr>
<td><?php echo $row_rsnews['Title'];?></td>
</tr>
<?php } while ($row_rsnews = mysql_fetch_assoc($rsnews));?>
</table>
</body>
</html>
<?php
mysql_free_result($rsnews);
?>
$random_result = rand($rsnews);
Hab
