[Resolved] While loop starts at #2

[zdislaw]

I am querying MySQL and looping through the resulting array. Pretty basic stuff, I know. Why am I not getting the first record in the array?

I'm sure it's because I need to tell it to start at record #0 or something like that, but not sure how to go about it.

Thanks!

$sql = "SELECT * FROM $table WHERE id=$id";

$result = mysql_query($sql) or die(mysql_error());

$myrow = mysql_fetch_array($result);

while ($myrow = mysql_fetch_array($result)) {

printf("%s %s %s <br />", $myrow2["firstname"], $myrow2["lastname"],$myrow2["title"]);

}

[Drakla]

$sql = "SELECT * FROM $table WHERE id=$id";

$result = mysql_query($sql) or die(mysql_error());


// Dohh - it's this row below that's your problem, as soon as you enter the while loop below this row is ditched or [see below]
$myrow = mysql_fetch_array($result);

while ($myrow = mysql_fetch_array($result)) {

printf("%s %s %s <br />", $myrow2["firstname"], $myrow2["lastname"],$myrow2["title"]);
}

This should work

$sql = "SELECT * FROM $table WHERE id=$id";

$result = mysql_query($sql) or die(mysql_error());

if(!$result) {blahhh blahhh... no result, etc}

do            

{

printf("%s %s %s <br />", $myrow2["firstname"], $myrow2["lastname"],$myrow2["title"]);
}
while ($myrow = mysql_fetch_array($result));

[zdislaw]

That's the ticket! Thanks a million Drakla.