# MYSQL search result loosing first record

**URL:** <https://forum.kirupa.com/t/mysql-search-result-loosing-first-record/243290>\
**Category:** programming\
**Created:** [November 5, 2007, 2:25pm UTC](https://forum.kirupa.com/t/mysql-search-result-loosing-first-record/243290 "2007-11-05T14:25:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![onemhunki](https://avatars.discourse-cdn.com/v4/letter/o/c57346/32.png) [@onemhunki](https://forum.kirupa.com/u/onemhunki)\
**Post date:** [November 5, 2007, 2:25pm UTC](https://forum.kirupa.com/t/mysql-search-result-loosing-first-record/243290/1 "2007-11-05T14:25:36Z")

</div>

Hi folks,

Simple search result to display records, code below does not display the first record. If I echo the total records found say 6, the echo code below only displays 5 records.

```php

while ($row2 = mysql_fetch_array($result_applicants2)){ 
$emails = $row2['email'];
echo "$emails, ";
			}

```

Any ideas?