Ok I have 45 minutes left to make this script default to show "a" listings on
the browse.php page and then show no listings on other pages by default for
some reason the _Server function stopped working what have I done wrong...
<?php //alphabetical
pagination links
// Function to create paging. function createPaging($selectedLetter =
null) { $letters = range('A','Z'); array_push($letters, 'nums');
$menu = ''; //if the page is browse default to A's if on other pages just
show pagination links and not default listings if ("browse.php" ==
$_SERVER['SCRIPT_FILENAME']) { $letter = "A"; }else { $letter =
NULL; } foreach($letters as
$letter) { if($letter == $selectedLetter && $selectedLetter !=
'nums') { $menu .= sprintf('%s ', $letter); }
else if($letter == $selectedLetter && $selectedLetter == 'nums') {
$menu .= sprintf('%s ', '#', '<hr>'); } 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); }
} } return $menu; echo ('<HR>'); } // Function to show just
paging. function index() { // Echo only paging. echo
createPaging(); } // Function to show results if page was given. function
browse($selectedLetter) { // Echo paging. echo
createPaging($selectedLetter); echo '<br>'; //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)) {
echo '<br>'; $name = $row['name']; printf('<br><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']);
} } } // Main controller which
page to show. if (isset($_GET['letter'])) {
browse($_GET['letter']); } else { index(); }
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
