EchoFool Posted January 15, 2008 Share Posted January 15, 2008 I keep getting this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY reportedusers.RecordID' at line 2 Not sure what is so wrong about it .... i did an ORDER BY then GROUP BY but it's not happy with it... this is what i got: $GetAppeals2 = mysql_query("SELECT * FROM reportedusers LEFT JOIN (reportsituation, staff) ON reportsituation.RecordID = reportedusers.RecordID AND reportsituation.SaidBy <> staff.UserID ORDER BY reportsituation.SaidTime GROUP BY reportedusers.RecordID") Or die(mysql_error()); Not even sure if the query will work but can't tell till i get the syntax correct Hope you can help. Quote Link to comment https://forums.phpfreaks.com/topic/86057-solved-syntax-error/ Share on other sites More sharing options...
trq Posted January 15, 2008 Share Posted January 15, 2008 i did an ORDER BY then GROUP BY Switch them around. Quote Link to comment https://forums.phpfreaks.com/topic/86057-solved-syntax-error/#findComment-439470 Share on other sites More sharing options...
EchoFool Posted January 15, 2008 Author Share Posted January 15, 2008 i did an ORDER BY then GROUP BY Switch them around. Argh thank you solved the syntax. My Query turns out to be wrong again lol. Hmm might have to freelance this one. Thanks for the help. Quote Link to comment https://forums.phpfreaks.com/topic/86057-solved-syntax-error/#findComment-439474 Share on other sites More sharing options...
revraz Posted January 15, 2008 Share Posted January 15, 2008 Or post in the MySQL forum for help, since that's what it is. Quote Link to comment https://forums.phpfreaks.com/topic/86057-solved-syntax-error/#findComment-439483 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.