select statement not showing any results

[nc_brox]

hi guys,

hope you can help. I'm trying to write a select statement where it returns all the postcodes that are within a given distance either side of a certain point. This is my code:

$query3 = mysql_query("SELECT Pcode FROM postcodes WHERE Distance BETWEEN '$max_distance' AND '$min_distance'");

I have a table called postcodes with the fields Pcode and Distance (among others), and I have defined $max_distance and $min_distance.

I can't work out how to display the results.... I'm not sure if it will be in an array, if I have to include a Loop or what. I have tried a number of different ways but none are working!!

If anyone can help I would be very grateful!! 🙂

[paulnaj]

Assuming that your SQL is OK, ...

<?php
while($assoc = mysql_fetch_assoc($query3)){
	echo '<br />'.$assoc['Pcode'];
}
?>

... but have a look at the php mysql_fetch_assoc entry in the manual to see about error checking results from queries.

P