Dynamic Navigation with Limit

[Nasreen Laghari <nasreen_laghari@xxxxxxxxx>]

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