Welcome to WebmasterWorld Guest from 184.72.177.182

Forum Moderators: open

Message Too Old, No Replies

MySQL query has rows but doesn't have data?

     
4:50 pm on Jan 5, 2010 (gmt 0)

Full Member

10+ Year Member

joined:May 13, 2004
posts:220
votes: 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).

Has any one else experienced this?

4:54 pm on Jan 5, 2010 (gmt 0)

Full Member

10+ Year Member

joined:May 13, 2004
posts:220
votes: 0


By the way, I have found a somewhat-reliable way around this issue, when it happens.

My intial query is this ...

SELECT DISTINCT field FROM table ORDER BY field

... and if I then change it to ...

SELECT field, COUNT( * ) FROM table GROUP BY field ORDER BY field

... it works fine (I just have to ignore the 2nd column in the resulting data).

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members