maxudaskin Posted January 30, 2008 Share Posted January 30, 2008 mysql_query("SELECT tpye, pid, SUM(totaltime) as sumValue FROM pireps WHERE type = '0' GROUP BY pid ORDER BY sumValue DESC LIMIT 5") Which outputs: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.grable/vzoom/virtualzoom.net/index.php on line 402 Quote Link to comment https://forums.phpfreaks.com/topic/88511-solved-i-did-it-again/ Share on other sites More sharing options...
Bauer418 Posted January 30, 2008 Share Posted January 30, 2008 My first assumption is that tpye should read type. But if that's not the case, try: mysql_query('your query here') or die(mysql_error()); That will tell you why your query is experiencing an error. Quote Link to comment https://forums.phpfreaks.com/topic/88511-solved-i-did-it-again/#findComment-453082 Share on other sites More sharing options...
maxudaskin Posted January 30, 2008 Author Share Posted January 30, 2008 Ok, so I cannot spell Quote Link to comment https://forums.phpfreaks.com/topic/88511-solved-i-did-it-again/#findComment-453084 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.