Missing first record when looping through array
I am using data from a recordset which I need in json format, but I find that when I loop through the array, the first row is missing from my json encoded page.
The code segment looks like this
mysql_select_db($database_PowerCMSConnection, $PowerCMSConnection);
$query_rscouncil = "SELECT ... FROM tblcontacts ...";
$rscouncil = mysql_query($query_rscouncil, $PowerCMSConnection) or die(mysql_error());
$row_rscouncil = mysql_fetch_assoc($rscouncil);
$totalRows_rscouncil = mysql_num_rows($rscouncil);
while($data = mysql_fetch_array($rscouncil)){
$outputdata[] = $data;
}
//that gives a multidimensional array, which can then be jsonified:
echo '{ "data":'. json_encode($outputdata)."}";
I know the recordset returns 16 rows, but my jsonified page only contains 15
After playing about with the sort order, it is the first row which is always omitted.
This is something I intend to overhaul with mysqli in future, but I have a set of existing pages I would like to fix
Thanks