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? Quote 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? Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.