Msg#: 4054578 posted 4:50 pm on Jan 5, 2010 (gmt 0)
This happens from time to time, and I can't figure out why. I'll set up a query, and mysql_query->rows will show that a certain number of rows of data were sent back ... but then I use mysql_query->fetchrow_array to loop through the rows, and nothing happens.
Strange. MySQL says a certain number of rows are returned, but then there's no data whatsoever.
I've looked at the query, I've troubleshoot'ed every which way, and yet this happens, repeatably (often it's when I want a single colum of all distinct values for a field).