On Mon, 2009-08-03 at 09:33 -0700, Miller, Terion wrote:
> Here is is incase anyone else ever needs it.
>
> //Create array with letters AND number
> sign $letters = range('A','Z');
> array_push($letters, 'nums');
> $menu = ''; $selectedLetter = isset($_GET['letter']) ?
> $_GET['letter'] : null; foreach($letters as $letter)
> { if($letter ==
> $selectedLetter && $selectedLetter != 'nums') {
> $menu .= sprintf('%s ', $letter);
> } else if($letter ==
> $selectedLetter && $selectedLetter == 'nums') {
> $menu .= sprintf('%s ', '#');
> } else {
> if($letter == 'nums')
> { $menu .= sprintf('<a
> href="browse.php?letter=%s">%s</a> ', 'nums', '#');
> } else
> { $menu .= sprintf('<a
> href="browse.php?letter=%s">%s</a> ', $letter, $letter);
> } }
> } echo "<div
> align=\"center\"><b>{$menu}</b><br /></div>";
>
>
> //Show all
> restaurants that start with $letter not between "A" and "Z"
> if ($selectedLetter == "nums") {
> for($i = 0; $i <= 9; $i++) {
> $sql = "SELECT DISTINCT ID, name, address FROM
> restaurants WHERE name LIKE '$i%'";
> $result =
> mysql_query($sql) or die(mysql_error());
> while($row = mysql_fetch_assoc($result))
> { $name = $row['name'];
> printf('<a
> href="view.php?ID=%s"><b>%s</b><br />%s<br /><br /></a>', $row['ID'],
> $row['name'], $row['address']);
> } }
> }
> else { $sql =
> "SELECT DISTINCT ID, name, address FROM restaurants WHERE name LIKE
> '$selectedLetter%'";
> $result = mysql_query($sql) or die(mysql_error());
> while($row = mysql_fetch_assoc($result))
> { $name = $row['name'];
> printf('<a href="view.php?ID=%s"><b>%s</b><br
> />%s<br /><br /></a>', $row['ID'], $row['name'], $row['address']);
> }
> }
>
> On 8/3/09 10:12 AM, "Miller, Terion" <tmil...@springfi.gannett.com> wrote:
>
>
>
>
> On 8/3/09 9:46 AM, "sono...@fannullone.us" <sono...@fannullone.us> wrote:
>
>
>
> On Aug 3, 2009, at 7:19 AM, Miller, Terion wrote:
>
> > Not sure why none of these are working for me since you have them
> > tested against your table....I get this error...
>
> Hopefully I'm not speaking out of turn here, but did you by any
> chance copy and paste that code from an e-mail? If so, there may be
> invisible characters masquerading as spaces. I use TextWrangler (on a
> Mac) and choose "Zap Gremlins..." so they show and then delete them.
> That usually solves the problem for me.
>
> Frank
>
>
> Thanks Frank, but yep I'm using an editor that is good about such things, I'm
> not sure what the problem can be. And I get all the way to noon to figure it
> out.
>
>
Just for the future, are you able to format your emails as pure text
before you send them, as they get real mangled by the time they reach us
otherwise! :p
Thanks,
Ash
http://www.ashleysheridan.co.uk
