Have you tried "View Page Source"?
- You have a blank entry at the top.
- Something goes bad in SQL at the end of the file.
- Your four character hrefs are not unique - look at all the "#Coun"
entries.
- Your second <ul> is Aberdeenshire, there are not other areas in the
list, that's why the other links don't work.
- That's not entirely true, London also works and displays the error I
mentioned earlier.
Hope that helps.
/Mogens
On 17-01-2011 17:38, [email protected] wrote:
hi, at the moment, my page only works with the County: Aberdeenshire
http://www.mypubspace.com/iphone/pubs
user: test
pass: test
List of Counties County List
Aberdeenshire County List
The code for my Pubs page is below...,
I think I need to change the hard coded bit that reads:
Code:
[code]
echo "<ul title=\"Pubs in Angus\" id=\"Angu\">";
[/code]
and the SQL string:
Code:
[code]
$query = "SELECT * FROM pubs WHERE rsCounty = 'Angus' LIMIT $offset,
$rowsPerPage";
[/code]
pubs page
[code]
<?php
include_once("config.php");
include_once("functions.php");
// Check user logged in already:
checkLoggedIn("no");
//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>My Pub Space</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/mps-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>
</head>
<body>
<?
$offset = (isset($_GET['start'])) ? (int)$_GET["start"] : 0;
$rowsPerPage = (isset($_GET['count'])) ? (int)$_GET["count"] : 10;
$query = "SELECT * FROM pubs WHERE rsCounty = 'Angus' 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);
$County1 = $result1['rsCounty'];
$CountyCount = $result1['County_Count'];
?>
<div class="toolbar">
<h1 id="pageTitle">Select County</h1>
<a id="backButton" class="button" href="#"></a>
<a class="button" href="logout.php" target="_self">Logout</a>
</div>
<ul title="Select County" id="county" selected="true">
<?php
while ($row = mysql_fetch_assoc($result1)){
$RSCOUNTY1 = $row['rsCounty'];
$RSCOUNTY1short = substr($row['rsCounty'],0,4);
$CountyCount = $row['County_Count'];
echo<<<EOF
<li><a href="#$RSCOUNTY1" class="digg-count">$CountyCount</a>
<a href="#$RSCOUNTY1short">$RSCOUNTY1</a></li>
EOF;
}
echo "</ul>";
// start East Sussex
echo "<ul title=\"Pubs in Angus\" id=\"Angu\">";
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?start=" . ($offset + $rowsPerPage) .
"&count={$rowsPerPage}\" target=\"_replace\">View More</a></li>";
//div container of header and information
echo<<<EOF
<li><a href="viewpub.php?PUBID=$PUBID">$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>";
// End East Sussex
?>
</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.
