Jump to content

Recommended Posts

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

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 :(

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.