MySQL Forums :: PHP :: Able to select multiple tables with manually generated (primary) keys, but not auto-numbered ones
Re: Barry Galbraith, here is some additional information
Posted by: Kurt Wayne ()
Date: March 09, 2012 06:11PM
Barry, almost there. (I'd post a link here to the output, in PHP as you said, but I'm not sure I'm supposed to.) 2 final questions:
1. The "radio" site same link is being repeated every row instead of being listed just once. (i.e. for one city there are six newspapers, 1 radio station...with six rows created for each newspaper, the same radio link is displaying on all six rows when I just want the one radio link to display once (in the first row)).
2. (And I know why this is happening...because we're joining on cities common to "brasil_newspapers" and "brasil_radio") There are a few cities in "Amapa" that don't have radio stations but do have newspaper sites. Any easy way to list those in a query like this?
1. The "radio" site same link is being repeated every row instead of being listed just once. (i.e. for one city there are six newspapers, 1 radio station...with six rows created for each newspaper, the same radio link is displaying on all six rows when I just want the one radio link to display once (in the first row)).
2. (And I know why this is happening...because we're joining on cities common to "brasil_newspapers" and "brasil_radio") There are a few cities in "Amapa" that don't have radio stations but do have newspaper sites. Any easy way to list those in a query like this?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates