Re: Filter array results... no copies

Matthew Ferry wrote:

Hello everyone.... I'm back working on the website again... I'm having lots of fun. I have a sql query that looks at one field in a database. (result2 query) Then i have mysql_fetch_array statement.

For future reference, if you only have a problem with one particular part of your page, please only post that part. The rest is unnecessary in this case. You can do this in two ways: - remove the duplicates through changing the query change: SELECT adr_one_region FROM egw_addressbook WHERE cat_id='8' ORDER BY adr_one_region to SELECT adr_one_region FROM egw_addressbook WHERE cat_id='8' GROUP BY adr_one_region ORDER BY adr_one_region - remove the duplicates in php $prev_region = ''; while ($area = mysql_fetch_assoc($result2)) { if ($prev_region == $area['adr_one_region']) {

    continue;

} echo "<a href='index.php?area=$area[adr_one_region]'>$area[adr_one_region]</a>\n"; echo " - "; } -- Postgresql & php tutorials http://www.designmagick.com/