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].
For more options, visit this group at
http://groups.google.com/group/iphonewebdev?hl=en.
