Chris wrote:
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 " - ";
}
Oops that should be:
$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 " - ";
$prev_region = $area['adr_one_region'];
}
(I wasn't resetting 'prev_region' at the end of that loop).
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
