I sort of understand what you mean here, so I need to add a query string to the link but how is it going to be different each time? like with a fresh 20 results added on?
On Jul 23, 10:30 pm, Victor Hudson <[email protected]> wrote: > $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.
