jarv Posted July 24, 2010 Share Posted July 24, 2010 hi, I have recently got into iUI from watching the Joe Hewitt video here: http://uk.video.yahoo.com/watch/853528/3491272 so far, I have managed to, from a normal login page go to a list of pubs taken from my database. My problem is when you touch/click on View More at the bottom of the list, this should show 20 more results, which it does but they are the same results, I need to build a query string of the next 20 results then the next 20 and so on... here is my current 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> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.