Dynamic Navigation with Limit
| From: | Nasreen Laghari | Date: | Thu, 03 Apr 2008 23:57:44 +0000 |
| Subject: | Dynamic Navigation with Limit | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44860@lists.php.net to get a copy of this message | ||
Hi,
I'm trying to put limit of data fetch as well as dynamic navigation. Below is the try which I
did but something is going wrong as $screen value is not increasing so when I click on NEXt button
it refreshes the same page and Previous button does even show.
Could you kindly have look on the coding and help me where i'm mistaking.
Regards
Nasreen
<?php
$rows_per_page = 10;
$i=0;
if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$sql = "SELECT * FROM gig g, venue v WHERE g.gigName LIKE '%".$gig_name."%'
OR g.gig_date LIKE '%".$sdate."%' OR g.genre LIKE
'%".$genre."%' OR g.ticket_price LIKE '%".$ticket_price1."%'
OR g.ticket_price LIKE '%".$ticket_price2."%' OR v.venueName LIKE
'%".$vname."%' OR v.vCity LIKE '%".$city."%' order by
gig_Date LIMIT $start,$rows_per_page";
$result = mysql_query($sql) or die("Query error: ". mysql_error());
$num_rows = mysql_num_rows($result) ;
$pages = ceil($num_rows / $rows_per_page);
$j=0;
while ($row = mysql_fetch_array($result))
{
global $limit;
$j = $j+1;
$gigid = $row['gigid'];
$gigname = $row['gigName'];
$sdate = $row['gig_fdate'];
$fdate =$row['gig_tdate'];
$genre = $row['genre'];
$ticket_price = $row['ticket_price'];
$gigdetail= $gigid;
echo("<br> $gigid <a href='detail.php?gigDetail=$gigid'>
$gigname</a>");
}
}
if ($screen > 0)
{
print <a href=\"view.php?$screen=".(
$screen+1)."\"><<Previous Entries</a> ";
}
else if ($screen < $pages)
{
$screen = $screen+1;
print "<a href=\"view.php?screen=".($screen)."\">Next
Entries>></a> ";
}
?>
____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No
Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com