I have a SQL statement that I use to grab movie profiles. When I constructed the input form, I decided I didn't want to use blank entries for tables that didn't have a entry for that particular film e.g. a poster wasn't available for sale.
This SQL statement in PHP works fine when EVERY table has an entry for a title: $sql="SELECT allposters.allpostersurl, allposters.imageurl, officialsites.url, profiles.photo, profiles.photoalt, profiles.profile, soundtracks.title AS cdtitle, soundtracks.asin, soundtracks.coverart, titles.titlesid, titles.releaseyear, titles.title FROM allposters, officialsites, profiles, soundtracks, titles WHERE allposters.titlesid=titles.titlesid AND officialsites.titlesid=titles.titlesid AND profiles.titlesid=titles.titlesid AND soundtracks.titlesid=titles.titlesid AND profiles.profilesid='$profileid'"; Of course, if one table is missing an entry for that film it turns up empty. I understand that MySQL (our host is using 3.22.32) doesn't support full outer joins which is what I think might be needed in this situation. Are my choices: a) code a separate SQL call for each table b) use a blank entry for the title if no other info exists or is there a third way to make that statement work? For those of you who use PHP, is there any pressing performance reason to use or not to use choice 'a'? Thanks! -- 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
