# Need help how come is display one record!

**URL:** <https://forum.kirupa.com/t/need-help-how-come-is-display-one-record/234647>\
**Category:** Uncategorized\
**Created:** [August 4, 2007, 7:39am UTC](https://forum.kirupa.com/t/need-help-how-come-is-display-one-record/234647 "2007-08-04T07:39:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rocky86](https://avatars.discourse-cdn.com/v4/letter/r/c2a13f/32.png) [@rocky86](https://forum.kirupa.com/u/rocky86)\
**Post date:** [August 4, 2007, 7:39am UTC](https://forum.kirupa.com/t/need-help-how-come-is-display-one-record/234647/1 "2007-08-04T07:39:34Z")

</div>

Hi ppl I need help with my php basically I manage to get my php to display the uname that matches the sql condition however it only return 1 record when there are 2 record that match the condition how do I make it display all record that matches the condition instead of displaying just one?  
This is my code:

```php

 
$resultpostal=mysql_query("SELECT location.uname,location.uid FROM location,districts WHERE districts.districtno ='56' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");
$counterx=0;
if($row=mysql_fetch_array($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}
 
 
    $report.="uid"."=".$temp[0]."&";
    $report.="uname"."=".$temp[1]."&";
 

```