The Little Guy Posted February 8, 2011 Share Posted February 8, 2011 I am getting this error: Warning: mysql_query(): Unable to save result set When I run this query: SELECT * FROM www where last_http_code != 200 order by rand() limit 1 What does that mean? how can I fix it? Link to comment https://forums.phpfreaks.com/topic/227082-unable-to-save-result-set/ Share on other sites More sharing options...
The Little Guy Posted February 9, 2011 Author Share Posted February 9, 2011 I have that query in a loop, and it works fine for a while, but after a while I get that error. does anyone know why this is happening? Link to comment https://forums.phpfreaks.com/topic/227082-unable-to-save-result-set/#findComment-1172033 Share on other sites More sharing options...
Muddy_Funster Posted February 10, 2011 Share Posted February 10, 2011 could it be reaching a thread limit? or perhaps it's buffer isn't clearing down after each runthrough? Just some ideas. Link to comment https://forums.phpfreaks.com/topic/227082-unable-to-save-result-set/#findComment-1172320 Share on other sites More sharing options...
The Little Guy Posted February 14, 2011 Author Share Posted February 14, 2011 It looks like it had to do with my RAND() Once I removed that, the error no longer showed up. Link to comment https://forums.phpfreaks.com/topic/227082-unable-to-save-result-set/#findComment-1174198 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.