Calling data from 3 MySQL tables
Posted 14 September 2006 - 02:06 PM
I'm trying in PHP to call out an SQL statement to enter data from 3 tables, now i've done it with two:
Select * FROM `cms_competitions`
LEFT OUTER JOIN cms_competition_pics
ON cms_competitions.competition_id = cms_competition_pics.competition_id
But how do include another table ie cms_competition_logos?
I understood a two table join, but a three i'm confused on?
Posted 14 September 2006 - 05:48 PM
but to do it with a left join, I'm not sure. You might need to use () to encapulate each LEFT OUTER JOIN command and then add a comma and another () to encapsulate another.
Try writing what you want to do in plain english (or your mother language if different) and translate it into pseudo code (semi-logical PHP). That might help.
Posted 14 September 2006 - 06:42 PM
Business Website: http://www.infotechnologist.biz
Personal Website: http://www.joyelpuryear.com
Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users