# Query returns only first row

**URL:** <https://forum.kirupa.com/t/query-returns-only-first-row/310717>\
**Category:** Uncategorized\
**Created:** [June 17, 2010, 2:08pm UTC](https://forum.kirupa.com/t/query-returns-only-first-row/310717 "2010-06-17T14:08:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![natronp](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@natronp](https://forum.kirupa.com/u/natronp)\
**Post date:** [June 17, 2010, 2:08pm UTC](https://forum.kirupa.com/t/query-returns-only-first-row/310717/1 "2010-06-17T14:08:09Z")

</div>

i have six test entries in the db which satisfy the query’s condition, but i’m only able to return the first item in the db… any thoughts?

```auto
<?php

require_once('connVars.php');

$loc = $_POST['id'];

$data = mysql_query("SELECT * FROM pics WHERE picLocID='$loc' AND picFlag=0 ORDER BY picDate DESC") 
or die(mysql_error());

if(mysql_num_rows($data))
{
echo '<?xml version="1.0" encoding="UTF-8"?>'; 
echo '<datapacket>'; 

while($row = mysql_fetch_array( $data )) 
{ 
$line= "<pic><picURL>".$row[picURL]."</picURL><picCaption>".$row[picCaption]."</picCaption><picPhotog>".$row[picPhotog]."</picPhotog><picDate>".$row[picDate]."</picDate><picDeviceID>".$row[picDeviceID]."</picDeviceID></pic>";
echo $line;
} 

echo "</datapacket>";
}else{
echo "error - connection error";
}

?>

```