SELECT DISTINCT..... but not quite as simple as that!
Posted: Mon Jan 05, 2009 6:33 am
Code: Select all
$result = mysql_query ("
SELECT * FROM matterusersrights
INNER JOIN matterdata ON matterdata.clientcode = matterusersrights.clientcode
WHERE matterusersrights.userid = $cookieid");
while ($row = mysql_fetch_object($result))
{
echo "<img src='images/icon_arrow.gif' />$row->persondealing<br/>";
}
mysql_free_result($result);
mysql_close($sqlconn);Everything in the mysql_query is essential.
Anyone know how to get this to be a distinct result?
Simon