Dynamic Navigation with Limit

From: 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)."\">&lt;&lt;Previous Entries</a> &nbsp; "; } else if ($screen < $pages) { $screen = $screen+1; print "<a href=\"view.php?screen=".($screen)."\">Next Entries&gt;&gt;</a> &nbsp; "; } ?> ____________________________________________________________________________________ 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

« previous php.db (#44860) next »