PHP/MySql sympton...

I have an interesting sympton. All my sql queries within PHP4 work fine except on this table. I had to add a dunny mysql_fetch_array to get it to work. Without it returns nothing in the array but mysql_num_rows returns correctly. $result = mysql_query("select distinct LD2 from LISTING"); /* I had to add this to get the darn thing to work */ $dummy = mysql_fetch_array($result); while($row = mysql_fetch_array($result)) { echo($row[LD2]); } Mysql table goes something like this... LID INT not null auto_increment LD1 CHAR(30) LD2 CHAR(30) LD3 CHAR(30) I'm running Solaris 2.7/PHP4pl1/Apache1.3.11. I've duplicated this on NT/PHP4pl1/Apache 1.3.12. Has anyone ran across this? or am I being blind again...? Tks in advance. Scott