mysql_fetch_array skipping first row

Question

I am using this same process to create and populate tables - Everything works fine except that the first row is skipped in every table. Could use another pair of eyes as I can't seem to pinpoint the issue. Thanks in advance.

   $query = "SELECT * FROM members";
   $results = mysql_query($query);
   $row = mysql_fetch_array($results);

   
   //echo my <table> start and headings;

    while ($row = mysql_fetch_array($results)) 
    {
    echo "<tr><td>".$row['Last Name']."</td>";
    echo "<td>".$row['First Name']."</td>";
    echo "<td>".$row['Middle Name']."</td>";
    echo "<td>".$row['Sfx']."</td>";
    echo "<td>".$row['Prf']."</td>";
    echo "<td>".$row['Spouse/SO']."</td>";
    echo "<td>".$row['Ancestor']."</td>";
    echo "<td>".$row['Status']."</td>";
    echo "<td>".$row['Address 1']."</td>";
    echo "<td>".$row['Address 2']."</td>";
    echo "<td>".$row['City']."</td>";
    echo "<td>".$row['ST']."</td>";
    echo "<td>".$row['Zip 5']."</td>";
    echo "<td>".$row['Zip 4']."</td>";
    echo "<td>".$row['Home Phone']."</td>";
    echo '<td><a href="mywebsite/mypage.php?id=' . $row['id'] . '">Bio</a></td></tr>';
    }

    echo "</table><hr>";

You're calling mysql_fetch_array twice, hence the reason. Remove the first call. — vee
– vee, Commented Aug 15, 2013 at 17:55
what @vinodadhikary said, your problem is line 3. If the commented code in line 6 needs it then change your loop to do { } while ($row = mysql_fetch_array($results)) — Sammitch
– Sammitch, Commented Aug 15, 2013 at 17:57
Ditto with John Conde and Chad. You should also use mysql_fetch_assoc() instead because mysql_fetch_array() pretty much doubles up on the amount of data that PHP is manipulating. — MonkeyZeus
– MonkeyZeus, Commented Aug 15, 2013 at 18:20

Orangepill · Accepted Answer · 2013-08-15 18:05:20Z

16

You are calling mysql_fetch_array twice... once before the loop then once while looping.

If you need a seed row for use in building your header row you might be better served with a do.. while loop here.

$query = "SELECT * FROM members";
$results = mysql_query($query);
$row = mysql_fetch_assoc($results);

//echo my <table> start and headings;

do  
{
    echo "<tr><td>".$row['Last Name']."</td>";
    echo "<td>".$row['First Name']."</td>";
    echo "<td>".$row['Middle Name']."</td>";
    echo "<td>".$row['Sfx']."</td>";
    echo "<td>".$row['Prf']."</td>";
    echo "<td>".$row['Spouse/SO']."</td>";
    echo "<td>".$row['Ancestor']."</td>";
    echo "<td>".$row['Status']."</td>";
    echo "<td>".$row['Address 1']."</td>";
    echo "<td>".$row['Address 2']."</td>";
    echo "<td>".$row['City']."</td>";
    echo "<td>".$row['ST']."</td>";
    echo "<td>".$row['Zip 5']."</td>";
    echo "<td>".$row['Zip 4']."</td>";
    echo "<td>".$row['Home Phone']."</td>";
    echo '<td><a href="mywebsite/mypage.php?id=' . $row['id'] . '">Bio</a></td></tr>';
} while ($row = mysql_fetch_assoc($results));

echo "</table><hr>";

edited Aug 15, 2013 at 18:05

answered Aug 15, 2013 at 17:58

Orangepill

24.7k3 gold badges44 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

vee Over a year ago

Nice one! Awesome suggestion with the do...while. But this might just confuse the OP! Some explanation on how do...while works and why the OP's code is not generating expected result would make it more awesome!

Craig Ralston Over a year ago

I'm quite familiar with the do...while - just needed some direction as I've been getting a little burnt out and these little things slip by me! Thanks!

John Conde · Accepted Answer · 2013-08-15 17:56:58Z

6

$query = "SELECT * FROM members";
$results = mysql_query($query);
$row = mysql_fetch_array($results); <-- There's your first row. Remove this.

answered Aug 15, 2013 at 17:56

John Conde

220k100 gold badges464 silver badges504 bronze badges

1 Comment

SaidbakR Over a year ago

This is because the first call sets the array pointer to the first element, and then the second call -in while loop- set the pointer to the second element.

Sumoanand · Accepted Answer · 2013-08-15 18:10:22Z

There is extra mysql_fetch_array in the code. Also, opening table tag(<table>) is missing.

Corrected code:

$query = "SELECT * FROM members";
$results = mysql_query($query);
echo "<table>";

while ($row = mysql_fetch_array($results)) 
{
echo "<tr><td>".$row['Last Name']."</td>";
echo "<td>".$row['First Name']."</td>";
echo "<td>".$row['Middle Name']."</td>";
echo "<td>".$row['Sfx']."</td>";
echo "<td>".$row['Prf']."</td>";
echo "<td>".$row['Spouse/SO']."</td>";
echo "<td>".$row['Ancestor']."</td>";
echo "<td>".$row['Status']."</td>";
echo "<td>".$row['Address 1']."</td>";
echo "<td>".$row['Address 2']."</td>";
echo "<td>".$row['City']."</td>";
echo "<td>".$row['ST']."</td>";
echo "<td>".$row['Zip 5']."</td>";
echo "<td>".$row['Zip 4']."</td>";
echo "<td>".$row['Home Phone']."</td>";
echo '<td><a href="mywebsite/mypage.php?id=' . $row['id'] . '">Bio</a></td></tr>';
}

echo "</table><hr>";

Tricky12 · Accepted Answer · 2013-08-15 17:57:27Z

0

You call mysql_fetch_array when you initialize $row, which reads the first row. You then call it a second time when you begin your while loop, which moves it to the second row before any of your loop is ran. Hence, it never does anything with the first row.

answered Aug 15, 2013 at 17:57

Tricky12

6,8301 gold badge30 silver badges36 bronze badges

Comments

azhar baloch · Accepted Answer · 2017-05-08 17:42:23Z

while ($row) 
{
echo "<tr><td>".$row['Last Name']."</td>";
echo "<td>".$row['First Name']."</td>";
echo "<td>".$row['Middle Name']."</td>";
echo "<td>".$row['Sfx']."</td>";
echo "<td>".$row['Prf']."</td>";
echo "<td>".$row['Spouse/SO']."</td>";
echo "<td>".$row['Ancestor']."</td>";
echo "<td>".$row['Status']."</td>";
echo "<td>".$row['Address 1']."</td>";
echo "<td>".$row['Address 2']."</td>";
echo "<td>".$row['City']."</td>";
echo "<td>".$row['ST']."</td>";
echo "<td>".$row['Zip 5']."</td>";
echo "<td>".$row['Zip 4']."</td>";
echo "<td>".$row['Home Phone']."</td>";
echo '<td><a href="mywebsite/mypage.php?id=' . $row['id'] . '">Bio</a></td></tr>';
  $row = mysql_fetch_array($results);

}

echo "</table><hr>";

Erwin van Hoof · Accepted Answer · 2022-11-29 11:04:43Z

0

To fix this, just comment out the 3rd line $row = mysql_fetch_array($results); The query will fetch every single row after that.

edited Nov 29, 2022 at 11:04

Erwin van Hoof

1,0126 silver badges17 bronze badges

answered Nov 25, 2022 at 2:10

Osei Divine

11 bronze badge

Collectives™ on Stack Overflow

mysql_fetch_array skipping first row

6 Answers 6

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related