Need quick got written up yesterday!! OUCH
| From: | Miller, Terion | 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 ', $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(); }
?>