include 'sub_nav.inc.php'; ?>
View our Restaurant contact details by postcode order below or by alphabetic by clicking on this link.
//include 'postcode_menu.inc.php'; ?>
$qry = "SELECT postcode_1 FROM `restaurant`"; $qry .= "WHERE `hide` = '1' AND FIELD( postcode_1, 'E1', 'EC1', 'EC2', 'EC3', 'NW1', 'SE1', 'SW1', 'SW3', 'SW4', 'SW5', 'SW6', 'SW7', 'SW10', 'SW11', 'W1', 'W2', 'W8', 'W11', 'W14', 'WC2') ORDER BY FIELD( postcode_1, 'E1', 'EC1', 'EC2', 'EC3', 'NW1', 'SE1', 'SW1', 'SW3', 'SW4', 'SW5', 'SW6', 'SW7', 'SW10', 'SW11', 'W1', 'W2', 'W8', 'W11', 'W14', 'WC2' ) ASC ,postcode_1"; $result = mysql_query($qry); $current_char = ''; while ($row = mysql_fetch_assoc($result)) { if ($row != 0 && $row['postcode_1'] != $current_char) { } if ($row['postcode_1'] != $current_char) { $current_char = $row['postcode_1']; echo ''.strtoupper($current_char) .' | '; } } ?> |
$qry = "SELECT `pricerange`, `hide`, `cuisine`, `id`,`telephone`, `address`,`postcode`, `name` , postcode_1 AS first_char FROM `restaurant`"; $qry .= "WHERE `hide` = '1' AND FIELD( postcode_1, 'E1', 'EC1', 'EC2', 'EC3', 'NW1', 'SE1', 'SW1', 'SW3', 'SW4', 'SW5', 'SW6', 'SW7', 'SW10', 'SW11', 'W1', 'W2', 'W8', 'W11', 'W14', 'WC2') ORDER BY FIELD( postcode_1, 'E1', 'EC1', 'EC2', 'EC3', 'NW1', 'SE1', 'SW1', 'SW3', 'SW4', 'SW5', 'SW6', 'SW7', 'SW10', 'SW11', 'W1', 'W2', 'W8', 'W11', 'W14', 'WC2' ) ASC ,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) .' '; } echo ''.$row['name'].' : '.$row['telephone'].', '.$row['address'].', '.$row['postcode'].' '; } ?> |
include 'footer.inc.php'; ?>