Re: paging

["Tony Marston" <tony@xxxxxxxxxxxxxxxxxxxxxxxx>]

Take a look at http://www.tonymarston.net/php-mysql/pagination.html

-- 
Tony Marston
http://www.tonymarston.net
http://www.radicore.org

"Jim Douglas" <jdz99@xxxxxxxxxxx> wrote in message 
news:COL119-W57B0A24AF94FCE04673622BBBD0@xxxxxxxxxx

Does anyone have a link to any examples of paging?

I have this example up and running,



http://www.w3schools.com/php/php_ajax_database.asp



I
have paging working as below, my problem is when I add a CSS style
sheet I now have 4 panes.  How can I direct the paging results to the
"content" pane?



<?php

$q=$_GET["q"];

$start=$_GET["start"];



$con = mysql_connect('localhost', 'root', 'mypassword');

if (!$con)

 {die('Could not connect: ' . mysql_error());}



mysql_select_db("bar", $con);

$page_name="getbars.php";



if(!isset($start)) {$start = 0;}



$sql2="select * from bars WHERE geog_id = '".$q."'";

$result2=mysql_query($sql2);

echo mysql_error();

$nume=mysql_num_rows($result2);



$eu = ($start - 0);

$limit = 10;

$this1 = $eu + $limit;

$back = $eu - $limit;

$next = $eu + $limit;

$sql="select * from bars WHERE geog_id = '".$q."' limit $eu, $limit";



$result = mysql_query($sql);



echo "<table border='0'>";

while($row = mysql_fetch_array($result))

  {

  if($bgcolor=='#f1f1f1'){$bgcolor='#ffffff';}

  else{$bgcolor='#f1f1f1';}

    echo "<tr >";


//echo "<td align=left bgcolor=$bgcolor
id='title'>&nbsp;<font face='Verdana' size='2'><A
HREF=" . $row['bar_website'] . "  >" . $row['bar_name'] .
"</A></div></font></td>";

        echo "<div id='lbBarList'> </div>";


echo "<td align=left bgcolor=$bgcolor
id='title'>&nbsp;<font face='Verdana' size='2'><A
HREF=" . $row['bar_website'] . "  >" . $row['bar_name'] .
"</A></div></font></td></div>";

  echo "</tr>";

}

echo "</table>";





if($nume > $limit ){ // Let us display bottom links if sufficient records 
are there for paging

  /////////////// Start the bottom links with Prev and next link with page 
numbers /////////////////

  echo "<table align = 'center' width='50%'><tr><td  align='left' 
width='30%'>";

  //// if our variable $back is equal to 0 or more then only we will display 
the link to move back ////////

   if($back >=0) {

     print "<a href='$page_name?start=$back'><font face='Verdana' 
size='2'>PREV</font></a>";

   }

}

echo "</td><td align=center width='30%'>";



$i=0;

$l=1;

for($i=0;$i < $nume;$i=$i+$limit){

    if($i <> $eu){

    //    echo " <a href='$page_name?start=$i'><font face='Verdana' 
size='2'>$l</font></a> ";

        echo " <a href='$page_name?start=$i'><font face='Verdana' 
size='2'>$l</font></a> ";

    }

        else { echo "<font face='Verdana' size='4' color=red>$l</font>";}

        $l=$l+1;

}



mysql_close($con);
_________________________________________________________________
Windows Live?: Keep your life in sync.
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t1_allup_howitworks_022009 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php