[Resolved] Blank row displayed

[revez2002]

The code for the page displayed below functions correctly, except for one thing; a blank row appears at the very top of the page, ahead of all of the rows that contain actual data that is contained in the database table that that I am trying to display.

What have I overlooked?

revez

<form method=post action="<?php $PHP_SELF; ?>">
<table>
<tr>
<td class="main_content"><b>Username</b></td>
<td class="main_content"><b>Firstname</b></td>
<td class="main_content"><b>Lastname</b></td>
<td class="main_content"><b>Phone</b></td>
<td class="main_content"><b>Email</b></td>
</tr>

<?php	
$sql = mysql_query("SELECT roster_ID, username, firstname, lastname, phone_number, email FROM ROSTER WHERE gref_ID='$gref_ID'"); 

do { 

$roster_ID_str = roster_ID.$index; 
$username_str = username.$index; 
$firstname_str = firstname.$index; 
$lastname_str = lastname.$index; 
$phone_number_str = phone_number.$index;
$email_str = email.$index;			

// Display each record returned by the query as a row
printf("<tr><td><input type=hidden name=\"%s\" value=\"%s\"><input class=\"trial\" type=text name=\"%s\" value=\"%s\" style=\"width:100px;\"></td> 
<td><input class=\"trial\" type=text name=\"%s\" value=\"%s\" style=\"width:100px;\"></td><td><input class=\"trial\" type=text name=\"%s\" value=\"%s\" style=\"width:100px;\"></td>
<td><input class=\"trial\" type=text name=\"%s\" value=\"%s\" style=\"width:100px;\"></td><td><input class=\"trial\" type=text name=\"%s\" value=\"%s\" style=\"width:200px;\"></td></tr>\n",  
$roster_ID_str, $row["roster_ID"], $username_str, $row["username"], $firstname_str, $row["firstname"], $lastname_str, $row["lastname"], $phone_number_str, $row["phone_number"], $email_str, $row["email"]); 
?> 

</table>
</form>

[paulnaj]

Hi revez,

Don't think this is the whole code ... currently will produce an error because the 'do' loop is not closed.

Anyway, the blank row is because you are using a do while loop rather than just a while loop.

With a do while loop, the first call to mysql_fetch_XXXX() is AFTER you have echo-ed the first line.

So change your ...

do {
//... innards
} while($row = mysql_fetch_XXXX($sql))

... to ...

while($row = mysql_fetch_XXXX($sql)){
//... innards
}

Paul 🙂

[revez2002]

Hi Paul,

Thanks for the recommendation. Yes, I only posted a snippet of the full body of the code, and I guess I left out the closing bracket on the do conditional.

I made the changes that you specified, and the problem is now resolved.

Thank you very much for your assistance!

revez 🙂