include 'sub_nav.inc.php'; ?>
View our Restaurant contact details by alphabetic order below or by postcode by clicking on this link.
$qry = "SELECT name , LEFT(name, 1) AS first_char FROM `restaurant`"; $qry .= "WHERE `hide` = '1' AND UPPER(name) BETWEEN 'A' AND 'Z' OR name BETWEEN '0' AND '9' ORDER BY name"; $result = mysql_query($qry); $current_char = ''; while ($row = mysql_fetch_assoc($result)) { if ($row != 0 && $row['first_char'] != $current_char) { } if ($row['first_char'] != $current_char) { $current_char = $row['first_char']; echo ''.strtoupper($current_char) .' | '; } } ?> |
$qry = "SELECT `pricerange`, `hide`, `cuisine`, `id`,`telephone`, `address`,`postcode`, `name` , LEFT(name, 1) AS first_char FROM `restaurant`";
$qry .= "WHERE (UPPER(name) BETWEEN 'A' AND 'Z' OR name BETWEEN '0' AND '9') AND `hide` = '1' ORDER BY name";
$result = mysql_query($qry);
$current_char = '';
while ($row = mysql_fetch_assoc($result)) {
if ($row != 0 && $row['first_char'] != $current_char)
{
echo '';
}
if ($row['first_char'] != $current_char)
{
$current_char = $row['first_char'];
echo ' '.strtoupper($current_char) .' [go back to top] '; } echo ''.$row['name'].' : '.$row['telephone'].', '.$row['address'].', '.$row['postcode'].' '; } ?> |
include 'footer.inc.php'; ?>