title: show matching mysql table results only once?
body: <p>hi I'm looking for a way to only show a matching set of mysql results only once. can anyone tell me how to do this?</p>
  
  <p>here's an example of what i'm trying to achieve:</p>
  
  <pre><code>id  |  profile_id  | viewed_profile_id | date_viewed
  1          4                7              00:00:00
  2          5                6              00:00:00
  1          4                7              00:00:00
  </code></pre>
  
  <p>so if profile_id and viewed_profile_id match then to only show one result for those matching columns rather than twice or three times or however many times it appears in the database?</p>