0
<?php
$query = "SELECT id, title, author, post, DATE_FORMAT(date, '%M %d, %Y') as sd FROM news_posts ORDER BY id desc";
$result = @mysql_query($query);
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$url = 'comments.php?id='.$row['id'];
echo '<p><b>'.$row['title'].'</b><br>
Written on '.$row['sd'].' by <b>'.$row['author'].'</b><br />
'.$row['post'].'<br />
<a href="java script:openComments(\''.$url.'\')">Add new comment or view posted comments</a></p>';
}
} else {
echo 'There are no news posts to display';
}
?>
With this script that makes pages after result of the number of mysql hits but I'm unfortunaly unlucky "/
<?php
if($_GET['page']) // Is page defined?
{
$page = $_GET['page']; // Set to the page defined
}else{
$page = 1; // Set to default page 1
}
$max = 3; // Set maximum to 10
$cur = (($page * $max) - $max); // Work out what results to show
$getdata = mysql_query("SELECT * FROM `news_posts` ORDER BY `id` DESC LIMIT $cur, $max") or die(mysql_error()); // select the results
$data = mysql_fetch_array($getdata); // get the data
$counttotal = mysql_query("SELECT * FROM `news_posts` ") or die(mysql_error()); // select all records
$counttotal = mysql_num_rows($counttotal); // count records
$total_pages = ceil($counttotal / $max); // dive the total, by the maximum results to show
if($page > 1){ // is the page number more than 1?
$prev = ($page - 1); // if so, do the following. take 1 away from the current page number
echo '<a href="?page=' . $prev . '">« Previous Page </a>'; // echo a previous page link
}
for($i = 1; $i <= $total_pages; $i++) // for each page number
{
if($page == $i) // if this page were about to echo = the current page
{
echo'<b>' . $i .'</b> '; // echo the page number bold
} else {
echo '<a href="?page=' . $i . '">' . $i . '</a> '; // echo a link to the page
}
}
if($page < $total_pages){ // is there a next page?
$next = ($page + 1); // if so, add 1 to the current
echo '<a href="?page=' . $next . '"> Next Page »</a>'; // echo the next page link
}
?>
can some one help me out ? its pretty urgent ^^^
thanks in advance and have a nice day
