Hi guys need some extra help/eye here to point out what am i doing wrong
basically i want to display the data from mydbase.by the way the purpose of this page is for posting article anyway what im trying to do is put a Next and previous navigation bar but it seems that even in displaying the data is not working any dea how to do it?
here's the complete code with the necessary changes (original code by himerus)
<?php
$server = "localhost";
$user = "root";
$pass = "";
$databasename = "mydatabase";
$db = mysql_connect($server, $user, $pass);
mysql_select_db($databasename,$db);
$sql = "SELECT * FROM php_blog ";
$query = mysql_query($sql,$db);
$total_results = mysql_num_rows($query);
$limit = "15"; //limit of archived results per page.
$total_pages = ceil($total_results / $limit); //total number of pages
if (empty($page))
{
$page = "1"; //default page if none is selected
}
$offset = ($page - 1) * $limit; //starting number for displaying results out of DB
$query = "SELECT * FROM php_blog ORDER BY timestamp DESC LIMIT 3 $offset, $limit";
$result = mysql_query($query);
//This is the start of the normal results...
while ($row = mysql_fetch_array($result))
{
$date = date("l F d Y", $row['timestamp']);
$title = stripslashes($row['title']);
$author = stripslashes($row['author']);
$cat = stripslashes($row['category']);
$intro = stripslashes($row['intro']);
}
mysql_close();
// This is the Previous/Next Navigation
echo "<font face=Verdana size=1>";
echo "Pages:($total_pages) "; // total pages
if ($page != 1)
{
echo "<a href=$PHP_SELF?page=1><< First</a> "; // First Page Link
$prevpage = $page - 1;
echo " <a href=$PHP_SELF?page=$prevpage><<</a> "; // Previous Page Link
}
if ($page == $total_pages)
{
$to = $total_pages;
}
elseif ($page == $total_pages-1)
{
$to = $page+1;
}
elseif ($page == $total_pages-2)
{
$to = $page+2;
}
else
{
$to = $page+3;
}
if ($page == 1 || $page == 2 || $page == 3)
{
$from = 1;
}
else
{
$from = $page-3;
}
for ($i = $from; $i <= $to; $i++)
{
if ($i == $total_results) $to=$total_results;
if ($i != $page)
{
echo "<a href=$PHP_SELF?showold=yes&page=$i>$i</a>";
}
else
{
echo "<b><font face=Verdana size=2>[$i]</font></b>";
}
if ($i != $total_pages)
echo " ";
}
if ($page != $total_pages)
{
$nextpage = $page + 1;
echo " <a href=$PHP_SELF?page=$nextpage>>></a> "; // Next Page Link
echo " <a href=$PHP_SELF?page=$total_pages>Last >></a>"; // Last Page Link
}
echo "</font>";
?>
and also this is the error that im getting
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\unlimusic_v11 Oct 13 2012\secured\test.php on line 24
Pages:(1) [1]