mysql_fetch_array skipping first row

by

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="https://stackoverflow.com/questions/18258675/mywebsite/mypage.php?id=" . $row['id'] . '">Bio</a></td></tr>';
} while ($row = mysql_fetch_assoc($results));

echo "</table><hr>";

More Related Contents:

  1. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  2. Php charset information [duplicate]
  3. Save the data into a database and return another value from database using PHP
  4. Math Symbol From Mysql To HTML? [closed]
  5. Create hyperlink from html table row to open record on a new page
  6. Is the following code valid? [closed]
  7. How to insert images into a database using PHP [closed]
  8. How to retrieve images from MySQL database and display in an html tag
  9. Preserve Line Breaks From TextArea
  10. How to upload images into MySQL database using PHP code
  11. Fetching data from MySQL database to HTML dropdown list
  12. HTML – Change\Update page contents without refreshing\reloading the page
  13. Delete multiple rows by selecting checkboxes using PHP
  14. “slash before every quote” problem [duplicate]
  15. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  16. How to add a delete button to a PHP form that will delete a row from a MySQL table
  17. Dynamic table in HTML using MySQL and php
  18. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  19. display data from SQL database into php/ html table [closed]
  20. Echo menu tree with recursive function
  21. How to display an BLOB image stored in MySql database?
  22. Sending HTML Code Through JSON
  23. PHP – Secure member-only pages with a login system
  24. PHP: Inserting Values from the Form into MySQL
  25. Creating dynamic tables in HTML using MySQL and PHP
  26. Create table with PHP and populate from MySQL
  27. Turkish characters are not displayed correctly [duplicate]
  28. Displaying BLOB image from Mysql database into dynamic div in html
  29. Using PHP to upload file and add the path to MySQL database
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment