$next = "<li><a href=\"all.php\" target=\"_replace\">View More</a></ li>";
There is no query string on the link url that would indicate which record subset to return. If all.php runs and returns the same query posted here you would get the same results back without the parameters. Vic Hudson On Fri, Jul 23, 2010 at 2:00 PM, [email protected] < [email protected]> wrote: > Ok so I am getting a list of 20 pubs, but when I hit View More at the > bottom, another 20 of the same pubs are shown?! > http://www.jbiddulph.com/iphone/pubs/default.php > > user: test > Pass: test > > [code] > <?php > include_once("config.php"); > include_once("functions.php"); > // Check user logged in already: > checkLoggedIn("yes"); > //doCSS(); ?> > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http:// > www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <meta http-equiv="Content-Type" content="text/html; > charset=iso-8859-1" /> > <title>gopub</title> > <link rel="stylesheet" type="text/css" href="stylesheets/style1.css" > title="default" /> > <meta name="viewport" content="width=device-width; initial-scale=1.0; > minimum-scale=1.0; maximum-scale=1.0; user-scalable=0;"/> > <link rel="apple-touch-icon" > href="../iui/iui/iui-logo-touch- > icon.png" /> > <style type="text/css" media="screen">@import > "../iui/iui/iui.css";</ > style> > <script type="application/x-javascript" > src="../iui/iui/iui.js"></ > script> > <meta name="apple-touch-fullscreen" content="YES" /> > <script type="text/javascript" src="js/jva.js"></script> > <style type="text/css"> > > body > ul > li { > font-size: 14px; > } > > body > ul > li > a { > padding-left: 54px; > padding-right: 40px; > min-height: 34px; > } > > li .digg-count { > display: block; > position: absolute; > margin: 0; > left: 6px; > top: 7px; > text-align: center; > font-size: 110%; > letter-spacing: -0.07em; > color: #93883F; > font-weight: bold; > text-decoration: none; > width: 36px; > height: 30px; > padding: 7px 0 0 0; > background: url(shade-compact.gif) no-repeat; > } > > h2 { > margin: 10px; > color: slateblue; > } > > p { > margin: 10px; > } > </style> > </head> > > <body> > > <? > // how many rows to show per page > $rowsPerPage = 20; > > // by default we show first page > $pageNum = 1; > > // if $_GET['page'] defined, use it as page number > if(isset($_GET['page'])) > { > $pageNum = $_GET['page']; > } > > $offset = ($pageNum - 1) * $rowsPerPage; > $query = "SELECT * FROM pubs LIMIT $offset, $rowsPerPage"; > $result = mysql_query($query) or die(mysql_error().'<br>SQL: ' . > $query); > > //looping counties > $query1 = "SELECT rsCounty, COUNT(PubID) AS County_Count FROM pubs > GROUP BY rsCounty"; > $result1 = mysql_query($query1) or die(mysql_error().'<br>SQL: ' . > $query1); > > $county_select_options = '<option value="">Search county</option>'; > while ($row = mysql_fetch_assoc($result1)) > { > $counties[$row['rsCounty']] = $row['County_Count']; > // $county_select_options .= '<option value="pubs.php?PubID='. > $row['id'].'">'.$row['rsCounty'].' (x'.$row['County_Count'].')</ > option>'."\n"; > } > // make this arrays not strings: > $values = array(); > $labels = array(); > // compute the sum: > $total = array_sum($counties); > foreach($counties as $rsCounty=>$count){ > // compute percent and add to values list: > $values[] = ($count*100/$total); > $labels[] = $rsCounty; > } > // convert array $values to a string comma separated > $values = implode(',',$values); > // same conversion for $labels but '|' separated > $labels = implode('|', $labels); > $url = 'http://chart.apis.google.com/chart?cht=p3&chd=t:'. > $values.'&chs=480x200&chl='.$labels.'&chco=b0d584'; > > ?> > <div class="toolbar"> > <h1 id="pageTitle"></h1> > <a id="backButton" class="button" href="#"></a> > <a class="button" href="#searchForm">Search</a> > </div> > <ul title="pubs" selected="true"> > <? > // start main page > while($row = mysql_fetch_array($result)){ > $PUBID = $row['PUBID']; > $RSPUBNAME = $row['RSPUBNAME']; > $RSADDRESS = $row['RSADDRESS']; > $RSPOSTCODE = $row['RSPOSTCODE']; > $RSTEL = $row['RSTEL']; > $RSTOWN = $row['RSTOWN']; > $RSCOUNTY = $row['RSCOUNTY']; > // how many rows we have in database > // print the link to access each page > $self = $_SERVER['PHP_SELF']; > $next = "<li><a href=\"all.php\" target=\"_replace\">View More</a></ > li>"; > //div container of header and information > echo <<<EOF > <li><a href="#">$RSPUBNAME</a></li> > EOF; > if ($_SESSION["RSUSER"] == "admin") > { > echo "<a href=\"edit.php?PUBID=$PUBID\" class=\"small\">edit this pub</ > a>"; > } > } > echo $next; > echo "</ul>"; > ?> > </body> > </html>[/code] > > -- > You received this message because you are subscribed to the Google Groups > "iPhoneWebDev" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<iphonewebdev%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/iphonewebdev?hl=en. > > -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en.
