Hi,
I have the feeling I'm missing something very obvious here, but it's driving me nuts! Using this select statement:
$result = mysql_query("SELECT * FROM latlong ",$link);
$nrows = mysql_num_rows($result);
and either of these to display the results:
for ($j=0; $rec=mysql_fetch_array($result); $j++){
print "j=$j id={$rec["id"]} seq={$rec["seq"]}\n";
}
while($row = mysql_fetch_array($result)){
echo "id={$row["id"]} seq={$row["seq"]} \n";
}
The very first record gets dropped/not displayed. The number of records returned ($nrows) matches what I get from MySQL and the first record gets displayed (using PHPMyAdmin). Even if I change the select to pull only certain records, the very first one does not get displayed.
Can anyone shed any light on this for me?
Thanks!
Paul
********************************************************************************************************
Paul H. Bern, Ph.D.
Numeric Data Services Librarian The only thing worse than not
352 Bird Library getting what you wanted
222 Waverly Ave. is getting what you asked for.
Syracuse, NY 13244
315-443-1352
http://library.syr.edu/information/mgi/nds
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
