looping through an array problem

[Jack Jackson <jackson.linux@xxxxxxxxx>]

This is something dumb I am doing but:

Trying to pull all names of publishers in db. This sql:

SELECT art.art_id,art.publisher_id,publisher.publisher_name,
FROM art
LEFT JOIN publisher
ON publisher.publisher_id=art.publisher_id

pulls (in phpmyadmin) four rows:
  artID  pubID     Publisher_name
  1        7       The New York Times: Sunday Styles
  2        3       The New York Sun
  3        2       Metro NY
  4        3       The New York Sun


I'm trying to make a sidebar which will make links to each unique 
publisher name:

while ($cartoon = mysql_fetch_assoc($result)) {
     $pub_sidebar[] = "<ul class='sidebar-menu'><a class='img-link' 
href='{$_SERVER['PHP_SELF']}?p={$cartoon['publisher_id']}' 
title=\"{$cartoon['publisher_name']}\">{$cartoon['publisher_name']}</a></ul>";
  }


This prints:
      The New York Times: Sunday Styles

      The New York Sun

      Metro NY

      The New York Sun


I'd like to stop the NY Sun from appearing twice! What have i missed here?

Thanks in advance!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php