MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Barry Galbraith, here is some additional information
Posted by: Barry Galbraith
Date: March 08, 2012 05:09PM

This query gets the info you need. 

SELECT n.newspaper_site
, n.facebook
, n.twitter
, r.radio_site
, r.rfacebook
, r.rtwitter
FROM brasil_newspapers n
JOIN brasil_radio r
ON r.city = n.city
WHERE n.state='Amapá' 
ORDER BY n.city;

Outputting that as html is a job for php.

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.