Thanks for your pointer. This SQL statement ended up working: Thanks for your pointer! This ended up working for me:
SELECT * FROM profiles LEFT JOIN allposters ON (profiles.titlesid = allposters.titlesid) LEFT JOIN officialsites ON (profiles.titlesid = officialsites.titlesid) LEFT JOIN titles ON (profiles.titlesid = titles.titlesid) LEFT JOIN soundtracks ON (profiles.titlesid = soundtracks.titlesid) WHERE profiles.profilesid='$profileid' -- Ian Evans Digital Hit Entertainment http://www.digitalhit.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php