PHP - Show First Letter Of A List Once?

I have got this far that my code shows the list but say nothing starts with the letter 'y' then all of the 'x' and 'z' are grouped in the list.

can anyone suggest a better way to have the list show correctly.

the 'multiItemBoxes' css class is a rounded box that shows around each letter group.

here is me code.
Code: [Select]
//
$letters = array(); $letters = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ ";
$L = 1;
?><div class="multiItemBoxes"><? // place first part of DIV.
$previousLetter = "/"; // set previousLetter to the letter before '0' zero. used as a dummy string.
while($results = mysql_fetch_assoc($getResults)) {
if ($previousLetter == "/") {
?><strong style="font-size: 15pt;"><? echo(strtoupper($results['productTitle'][0])); ?></strong><br /><?
}
if (strtoupper($results['productTitle'][0]) == $letters[$L]) {
?></div><? // this is the ending of the DIV. If needed.
?><br class="clearfloat" />
<? if (strtoupper($results['productTitle'][0]) != " ") {
?><div class="multiItemBoxes"><strong style="font-size: 15pt;"><? echo(strtoupper($results['productTitle'][0])); ?></strong><br /><?
$L++;
}
// this is the extra DIV start if not at end of DB list.
}
?><a href="<? echo("cart.php?query=" . $results['Pid']); ?><? echo("&amp;"); ?>i=y"><? echo(htmlspecialchars($results['productTitle'])); ?></a><br /><?
$previousLetter = $results['productTitle'][0];
} // end of while
?></div><br class="clearfloat" /><?
//

hello, im trying to see if there is a function that can get the value of the last row in mysql and see what is in field initial (this is letters A-Z) and make it one letter higher.  then, when it reaches letter Z, wrap around to A again.

I am using Concrete5 on a site I'm working on. Below is the News List display view.php file needed in the block to display the content from news pages. The code allows images entered in the WSYIWYG to appear in the RSS list. I want to know how I can edit the code below, so it shows only the these images from the $content not the text. Can anybody help me on this? Thanks


<?php     
defined('C5_EXECUTE') or die("Access Denied.");
    $html = Loader::helper('html');
    $uh = Loader::helper('concrete/urls');
    $bt = BlockType::getByHandle('news_list');
    global $c;


   $rss_address = $controller->getRssUrl().'?ctID='.$ctID.'&bID='.$bID ;

    if (isset($_GET['pageno'])) {
    $pageno = $_GET['pageno'];
} else {
    $pageno = 1;
} // if
?>

<div class="newsflash">
<div class="headtitle">
        <h1><?php echo $rssTitle ?></h1>
        </div>
<?php    



if (!function_exists('newslistParse')) {

function newslistParse($url,$thumbnail,$thumbwidth,$time,$content,$title,$date){

//###################################################################################//
//here we lay out they way the page looks, html with all our vars fed to it  //
//this is the content that displays.  it is recommended not to edit anything beyond //
//the content parse.  Feel free to structure and re-arrange any element and adjust //
//CSS as desired. //
// available vars:  $url,$thumbnail,$thumbwidth,$time,$content,$title,$date       //
//###################################################################################//

?>
<div class="newsflashcontain">
  <div class="title">
   <?php echo $title ; ?>
  </div>
  <div class="time">
   <?php echo $date ; ?><?php echo $time ; ?>
  </div>
  <div class="description">
<?php echo $content; ?>
  </div>
</div>
<?php    

//#####################################################################################//
//this is the end of the recommended content area.  please do not edit below this line //
//#####################################################################################//

}
}


$db = Loader::db();

//go grab the posts, check if they are current, return only current posts
Loader::model('newzy','simplenews');
$news = NewsCheck::getCurrentBlocks($ctID,$ordering);

//count the number of current posts returned
$pcount = count($news);

//if no events are returned, then we display a user defined message
if($pcount==0){
echo $nonelistmsg;
}

//now calc the last page
$lastpage = ceil($pcount/$num);


//set the current page min max keys -1 as array key's start @ 0
$sKey = $num * ($pageno-1) ;
$eKey = ($num * ($pageno-1)) + ($num-1) ;


//take each current post and treat it like a query, for each one do X
foreach($news as $key => $row){

//check for external URL, if none, rout to parent page
if(!empty($row['urlLink'])){
$url = $row['urlLink'];
}else{
$url = $controller->grabURL($row['cParentID']); 
}
//check if thumbnail is there, if so get it, if not, null
if($row['graphic']>0){
$thumbnail = $controller->getThumbnail($row['graphic']);
}else{
$thumbnail = NULL;
}
//set vars
$time = $controller->replaceTimeString($row['nbID']);
$date = $row['sdt'];
$title = $row['title'];
//$content = strip_tags($controller->translateFrom($row['content']));
$content = $controller->translateFrom($row['content']);
//if truncation is enabled
if($truncateSummaries == 1){
if (strlen($content) >= $truncateChars){
//truncate to suplied truncation value
 //$content = substr($content,0,$truncateChars).'.....';
 $content = wordwrap($content, $truncateChars);
     $content = substr($content, 0, strpos($content, "\n")).'.....';
}
}


//check if paging is enabled
if($isPaged){

//check to make sure the array key is within the range
if($key >= $sKey && $key <= $eKey){
  newslistParse($url,$thumbnail,$thumbwidth,$time,$content,$title,$date);
}

//if paging is not selected, use number of items designated in the list block
}else{

$i += 1;

newslistParse($url,$thumbnail,$thumbwidth,$time,$content,$title,$date);

//once we reach the set number stop the script
if($i >= $num){ break; }

}
}

?>
</div>
<?php    

//is iCal feed option is sellected, show it
if($showfeed==1){
?>
    <div class="rssfeed">
        <img src="<?php echo $uh->getBlockTypeAssetsURL($bt, 'rss.png');?>" width="14" height="14" alt="rss feed" />&nbsp;&nbsp;
        <a href="<?php echo $rss_address ; ?>" id="getFeed">Get this Feed</a>
        <link href="<?php echo $controller->getRssUrl();?>" rel="alternate" type="application/rss+xml" title="<?php      echo t('RSS');?>" />
    </div>
     <?php    
}

//$c = Page::getCurrentPage();
$link = Loader::helper('navigation')->getLinkToCollection($c);
$link = $controller->URLfix($link);

//if pagination is set, if it is needed, show it
if($isPaged==1){

if ($pcount > $num) {
echo '<div id="pagination">';

if ($pageno == 1) {
    echo " FIRST PREV ";
} else {
    echo '<a href="'.$link.'pageno=1">FIRST </a>';
    $prevpage = $pageno-1;
    echo '<a href="'.$link.'pageno='.$prevpage.'"> PREV</a>';
} // if

echo ' ( Page '.$pageno.' of '.$lastpage.' ) ';

if ($pageno == $lastpage) {
    echo " NEXT LAST ";
} else {
    $nextpage = $pageno+1;
    echo '<a href="'.$link.'pageno='.$nextpage.'">NEXT </a>';
    echo '<a href="'.$link.' pageno='.$lastpage.'"> LAST</a>';
} // if
echo '</div>';
}
}

if (isset($bID)) { echo '<input type="hidden" name="bID" value="'.$bID.'" />';}

?>

hi, at the moment, my page only works with the County: Angus (2nd in the list)

List of Counties County List

Angus County List


The code for my Pubs page is below...,

I think I need to change the hard coded bit that reads:
Code: [Select]
echo "<ul title=\"Pubs in Angus\" id=\"Angu\">";

and the SQL string:
Code: [Select]
$query  = "SELECT * FROM pubs WHERE rsCounty = 'Angus' LIMIT $offset, $rowsPerPage";

pubs page
Code: [Select]
<?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>

Please help?!

 hi,
I would like to show a list of pubs in a town that the user has selected from the drop down list

http://www.mypubspace.com/dashtest/order.html

it is all there working but in a different way

If you type Brighton into the Town search, it shows a list of pubs in that town, GREAT!

If you click the 'show towns list' link, a drop down appears, (this is where my problem is) When you click the town, I would like to get the list of pubs in that town

basically get rid of the form where you type in the box and click the button

here is my code HTML and Javascript
Code: [Select]
<html>
<body>

<script language="javascript" type="text/javascript">
<!--
//Browser Support Code
function ajaxFunction(){
var townRequest;  // The variable that makes Ajax possible!

try{
// Opera 8.0+, Firefox, Safari
townRequest = new XMLHttpRequest();
} catch (e){
// Internet Explorer Browsers
try{
townRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try{
townRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e){
// Something went wrong
alert("Your browser broke!");
return false;
}
}
}
// Create a function that will receive data sent from the server
townRequest.onreadystatechange = function(){
if(townRequest.readyState == 4){
var ajaxDisplay = document.getElementById('ajaxDiv');
ajaxDisplay.innerHTML = townRequest.responseText;
}
}
var name = document.getElementById('name').value;
var county = document.getElementById('county').value;
var town = document.getElementById('town').value;
var queryString = "?name=" + name + "&county=" + county + "&town=" + town;
townRequest.open("GET", "http://www.mypubspace.com/dashtest/pubs.php" + queryString, true);
townRequest.send(null);
}



function townlistFunction(){
var ajaxRequest;  // The variable that makes Ajax possible!

try{
// Opera 8.0+, Firefox, Safari
ajaxRequest = new XMLHttpRequest();
} catch (e){
// Internet Explorer Browsers
try{
ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try{
ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e){
// Something went wrong
alert("Your browser broke!");
return false;
}
}
}
// Create a function that will receive data sent from the server
ajaxRequest.onreadystatechange = function(){
if(ajaxRequest.readyState == 4){
var ajaxDisplay = document.getElementById('ajaxTownlist');
ajaxDisplay.innerHTML = ajaxRequest.responseText;
}
}
ajaxRequest.open("GET", "http://www.mypubspace.com/dashtest/town-select.php", true);
ajaxRequest.send(null);
}

function countylistFunction(){
var ajaxRequest;  // The variable that makes Ajax possible!

try{
// Opera 8.0+, Firefox, Safari
ajaxRequest = new XMLHttpRequest();
} catch (e){
// Internet Explorer Browsers
try{
ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try{
ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e){
// Something went wrong
alert("Your browser broke!");
return false;
}
}
}
// Create a function that will receive data sent from the server
ajaxRequest.onreadystatechange = function(){
if(ajaxRequest.readyState == 4){
var ajaxDisplay = document.getElementById('ajaxCountylist');
ajaxDisplay.innerHTML = ajaxRequest.responseText;
}
}
ajaxRequest.open("GET", "http://www.mypubspace.com/dashtest/county-select.php", true);
ajaxRequest.send(null);
}

function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}

//-->
</script>

<a href="#" onClick="townlistFunction();">show towns list</a>
<a href="#" onClick="countylistFunction();">show counties list</a>
<div id="ajaxTownlist"></div>
<div id="ajaxCountylist"></div>



<form name='myForm'>
Pub Name: <input type='text' id='name' /> <br />
County: <input type='text' id='county' />
<br />
Town: <input type='text' id='town' />
<input type='button' onclick='ajaxFunction()' value='Query MySQL' />
</form>
<div id='ajaxDiv'></div>
</body>
</html>



here is my pubs.php code
Code: [Select]
<?php
$dbhost = "xxx";
$dbuser = "xxx";
$dbpass = "xxx";
$dbname = "xxx";
//Connect to MySQL Server
mysql_connect($dbhost, $dbuser, $dbpass);
//Select Database
mysql_select_db($dbname) or die(mysql_error());
// Retrieve data from Query String
$name = $_GET['rsPubName'];
$sex = $_GET['rsTown'];
$wpm = $_GET['rsCounty'];
// Escape User Input to help prevent SQL Injection
$name = mysql_real_escape_string($name);
$town = mysql_real_escape_string($town);
$county = mysql_real_escape_string($county);
//build query
$query = "SELECT * FROM pubs WHERE rsTown = '$town'";
$qry_result = mysql_query($query) or die(mysql_error());

//Build Result String
$display_string = "<table>";
$display_string .= "<tr>";
$display_string .= "<th>Region</th>";
$display_string .= "<th>Pub Name</th>";
$display_string .= "<th>Town</th>";
$display_string .= "<th>County</th>";
$display_string .= "</tr>";

// Insert a new row in the table for each person returned
while($row = mysql_fetch_array($qry_result)){
$display_string .= "<tr>";
$display_string .= "<td>$row[Region]</td>";
$display_string .= "<td>$row[rsPubName]</td>";
$display_string .= "<td>$row[rsTown]</td>";
$display_string .= "<td>$row[rsCounty]</td>";
$display_string .= "</tr>";

}
$display_string .= "</table>";
echo $display_string;
?>

here is my town_select.php code
Code: [Select]
<?php
$dbhost = "xxx";
$dbuser = "xxx";
$dbpass = "xxx";
$dbname = "xxx";
//Connect to MySQL Server
mysql_connect($dbhost, $dbuser, $dbpass);
//Select Database
mysql_select_db($dbname) or die(mysql_error());
// Retrieve data from Query String
$town = $_GET['rsTown'];
// Escape User Input to help prevent SQL Injection

$town = mysql_real_escape_string($town);
//build query
$query = "SELECT DISTINCT rsTown, COUNT(PUBID) As PubCount FROM pubs GROUP BY rsTown  ORDER BY rsTown ASC";
$qry_result = mysql_query($query) or die(mysql_error());

// Insert a new row in the table for each person returned
  

$display_string .= "<form name=\"form3\" method=\"post\" action=\"\">";
$display_string .= "<select name=\"menu2\" onChange=\"MM_jumpMenu('parent',this,0)\" class=\"textbox\">";
$display_string .= "<option value=\"\">Search by Town...</option>";
while($row = mysql_fetch_array($qry_result)){
$display_string .= '<option value="rsTown='.$row['rsTown'].'" onclick=\"ajaxFunction()\" id=\"town\">'.$row['rsTown'].'&nbsp;('.$row['PubCount'].')</option>';
}
$display_string .= "</select>";
$display_string .= "</form>";

echo $display_string;
?>