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


SELECT adr_one_region FROM egw_addressbook WHERE cat_id='8' ORDER BY adr_one_region


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']) {
echo "<a href='index.php?area=$area[adr_one_region]'>$area[adr_one_region]</a>\n";
  echo " - ";

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to