While loop returning records 2 and higher. Where's the first?

[DeZiner]

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

printf (&quot;<a href='calldetail.php?id=%s' target='_blank'>%s</a> <br>&quot;, $myrow[7],$myrow[5]);

Using this, the first record is not returned. Only records 2 and higher that are in the databse.

Any thoughts. If you need more info, please let me know.

DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[skiflyer]

Odds are your query is what's actually eliminating your first two rows, or you have some lines between your...

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

line.

I would suggest dumping your $sql variable (hoping you're using one) to the browser, cut'n'paste it to something like phpmyadmin, and verify that it's returning what you think it is.

I would also suggest a simple function like...

function showResults($sql) {
  $result=mysql_query($sql) or die(mysql_error());
  echo '<pre>';
  while ($row=mysql_fetch_assoc($result)) {
    print_r($row);
  }
}

Which could be used to show you exactly what's being returned.

 

[sleipnir214]

DeZiner:

Check to make sure that the only place you're invoking mysql_fetch_*() is at the beginning of that while loop.

DreamWeaver, for example, will sometimes put a spurious fetch in the code.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[DRJ478]

Also:
For clarity I would recommend to use mysql_fetch_assoc().
The resulting array is keyed by the column names. Then you can use $myrow['mycolumn'] instead of $myrow[7] which doesn't tell anything about what's in there.