Getting ALL values from a table

[kaneos]

I have a table with a list of towns and cities with their postcode and latitude and longitude. Since a lot of small towns in an area have the same postcode.

 

I have a search which I want to return all towns that have the same postcode.

 

the table is set up as:

 

postcode:::::::town::::::::lat:::::::::long

[MasterACE14]

are the cities in a different table? and what is the name of the table above?

 

I'm assuming you're using MySQL. MySQL SELECT syntax

[kaneos]

the table name is postcodes, the cities are all under the towns column. yes I am using MySQL

[Drummin]

<?php
//assuming postcode will be some value gathered from a post or get action.
$postcode="12345";
$listcitys = mysql_query("SELECT town,lat,long FROM postcodes WHERE postcode=$postcode");
WHILE($lstctys = mysql_fetch_array($listcitys)) {
$town=$lstctys['town'];
$lat=$lstctys['lat'];
$long=$lstctys['long'];
// you can list this in many ways.  I'll just echo
echo "Town: $town  Lat: $lat  Longitude: $long<br />";
}
?>

[kaneos]

I have just put this into a php file with the connection file included and it does not seem to want to print anything out on the page. any suggestions? I have been through and checked that all my table fields match up.

[litebearer]

please show us YOUR code

[kaneos]

<?php

include "connectionfile.php";

$postcode = $_GET["postcode"];


$listcitys = mysql_query("SELECT town, lat, long FROM postcodes WHERE postcode=$postcode");
WHILE($lstctys = mysql_fetch_array($listcitys)) {
$town=$lstctys['town'];
$lat=$lstctys['lat'];
$long=$lstctys['long'];

echo "Town: $town  Lat: $lat  Longitude: $long<br />";
}
?>

[kaneos]

I just realized that there was a conflict with having 'long' as a table field and have changed it to 'lng', this has made the town and latitude appear however the longitude will still not show up.

 

new source

 

<?php

include "connectionfile.php";



$postcode="2533";
$listcitys = mysql_query("SELECT town, lat, lng  FROM postcode WHERE postcode=$postcode");
WHILE($lstctys = mysql_fetch_array($listcitys)) {
$town=$lstctys['town'];
$lat=$lstctys['lat'];
$long=$lstctys['long'];

echo "Town: $town  Lat: $lat  Longitude: $long<br />";
}
?>

[litebearer]

didn't carry change thru to here $long=$lstctys['long'];