MySQL Forums :: PHP :: Able to select multiple tables with manually generated (primary) keys, but not auto-numbered ones

INSERT INTO `brasilbrazil`.`brasil_newspapers` (`key`, `state`, `city`, `newspaper`, `newspaper_site`, `facebook`, `twitter`) VALUES (NULL, 'Amapá', 'Macapá', 'Aqui Amapá', 'http://www.aquiamapa.com.br', '', '');

INSERT INTO `brasilbrazil`.`brasil_radio` (`key`, `state`, `city`, `radio`, `radio_site`, `rfacebook`, `rtwitter`) VALUES (NULL, 'Amapá', 'Macapá', 'Amapá FM 93.3', 'http://www.redeamazonica.com.br/radio/amapafm/', '', '');



Barry,

Above are two SQL Insert statements I just created. Hope this can help. Also, here is how I'd like my data to display:


(TABLE)

(City) (Newspaper site (hyperlinked)) (Facebook site* (hyperlinked)) (Twitter site* (hyperlinked)) (Radio site* (hyperlinked)) (Radio Facebook site* (hyperlinked)) (Radio Twitter site* (hyperlinked))

(/TABLE)

*If site exists