Need quick got written up yesterday!! OUCH

From: Date: Tue, 04 Aug 2009 14:16:59 +0000
Subject: Need quick got written up yesterday!! OUCH
Groups: php.general 
Request: Send a blank email to php-general+get-296258@lists.php.net to get a copy of this message
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&nbsp', $letter); } else if($letter == $selectedLetter && $selectedLetter == 'nums') { $menu .= sprintf('%s&nbsp', '#', '<hr>'); } else { if($letter == 'nums') { $menu .= sprintf('<a href="browse.php?letter=%s">%s</a>&nbsp;', 'nums', '#'); } else { $menu .= sprintf('<a href="browse.php?letter=%s">%s</a>&nbsp; ', $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(); } ?>

« previous php.general (#296258) next »