thefollower Posted December 25, 2007 Share Posted December 25, 2007 I have a query which is meant to group the users that the person has contacted.. for example: Say i contacted user id 2 twice... in the list it will only show it as once. At the moment how ever it is displaying like this: Contacted Users: 2 2 Which is wrong. It should group 2 to become 1. Like so: Contacted Users: 2 This is what i got: <?php $GetConversation = mysql_query("SELECT *, IF(Sender='$ID', Receiver, Sender) as otherPartyID FROM messages UNION SELECT *, IF(Sender='$ID', Receiver, Sender) as otherPartyID FROM textmessages UNION SELECT *, IF(Sender='$ID', Receiver, Sender) as otherPartyID FROM phonecalls WHERE Sender='$ReportedPlayer' OR Receiver='$ReportedPlayer' GROUP BY otherPartyID ") or die(mysql_error()); ?> Link to comment https://forums.phpfreaks.com/topic/83147-solved-query-group-by-not-quite-correct/ Share on other sites More sharing options...
thefollower Posted December 25, 2007 Author Share Posted December 25, 2007 I also tried this: <?php $GetConversation = mysql_query("SELECT *, IF(Sender='$ID', Receiver, Sender) as otherPartyID FROM messages WHERE Sender='$ReportedPlayer' OR Receiver='$ReportedPlayer' UNION SELECT *, IF(Sender='$ID', Receiver, Sender) as otherPartyID FROM textmessages WHERE Sender='$ReportedPlayer' OR Receiver='$ReportedPlayer' UNION SELECT *, IF(Sender='$ID', Receiver, Sender) as otherPartyID FROM phonecalls WHERE Sender='$ReportedPlayer' OR Receiver='$ReportedPlayer' GROUP BY otherPartyID ") or die(mysql_error()); ?> But that failed to get any rows so that can't be correct Link to comment https://forums.phpfreaks.com/topic/83147-solved-query-group-by-not-quite-correct/#findComment-422914 Share on other sites More sharing options...
thefollower Posted December 25, 2007 Author Share Posted December 25, 2007 Bump Link to comment https://forums.phpfreaks.com/topic/83147-solved-query-group-by-not-quite-correct/#findComment-422946 Share on other sites More sharing options...
revraz Posted December 25, 2007 Share Posted December 25, 2007 Since this is mainly a SQL question, you may have better luck in the MySQL forum. Link to comment https://forums.phpfreaks.com/topic/83147-solved-query-group-by-not-quite-correct/#findComment-422953 Share on other sites More sharing options...
thefollower Posted December 25, 2007 Author Share Posted December 25, 2007 Ok. Thanks. Link to comment https://forums.phpfreaks.com/topic/83147-solved-query-group-by-not-quite-correct/#findComment-422993 Share on other sites More sharing options...
Recommended Posts