Re: looping through an array problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jack Jackson wrote:
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!
why are you pulling art_id and such? Just pull everything from the publisher table, and show that...

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux