jarv Posted July 25, 2010 Share Posted July 25, 2010 ok yesterday I got a list of pubs to show in my iui, I have recently added another <ul><li> at the top of the page to show the Counties list first but the result comes back like this: here is my 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> <? $offset = (isset($_GET['start'])) ? (int)$_GET["start"] : 0; $rowsPerPage = (isset($_GET['count'])) ? (int)$_GET["count"] : 10; $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); $County1 = $result1['RSCOUNTY']; $CountyCount = $result1['County_Count']; ?> <div class="toolbar"> <h1 id="pageTitle"></h1> <a id="backButton" class="button" href="#"></a> <a class="button" href="#searchForm">Search</a> </div> <ul title="county" selected="true"> <?php while ($row = mysql_fetch_assoc($result1)) { echo "<ul title=\"county\" selected =\"true\">"; echo <<<EOF <li><a href="#">$County1</a></li> <li><a href="#">$County1</a></li> EOF; } echo "</ul>"; // 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?start=" . ($offset + $rowsPerPage) . "&count={$rowsPerPage}\" target=\"_replace\">View More</a></li>"; //div container of header and information echo "<ul title=\"pubs\">"; 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.