[Vince]

That will only load half the results because both mysql_retrieve_row and mysql_fetch_row_format advance the row pointer. So you'll end up with one row loaded, one row skipped, one row loaded, one row skipped ... Fetch the row in the while clause. Delete mysql_retrieve_row.