Is this the correct way to write this Join?

run2web

Using MySQL:

$query_interred = "SELECT * FROM $interred, $plots, $own WHERE $interred.OwnerID=$owners.ID AND $interred.PlotID=$plots.ID";

And then when I want to access the specific tables would it be written like so?:

        $where_clauses=array(); 
    // if the Section Number has a value 
    if ($_POST['SectionNumber']){ 
    $where_clauses[] = "SectionNumber LIKE '$plots.$SectionNumber%'";  

    }

This is my first attempt at using joins so I am a lot confused.

TIA

Rayn

Originally posted by run2web
Using MySQL:
$query_interred = "SELECT * FROM $interred, $plots, $own WHERE $interred.OwnerID=$owners.ID AND $interred.PlotID=$plots.ID";  
And then when I want to access the specific tables would it be written like so?:
        $where_clauses=array(); 
    // if the Section Number has a value 
    if ($_POST['SectionNumber']){ 
    $where_clauses[] = "SectionNumber LIKE '$plots.$SectionNumber%'";  

    }
This is my first attempt at using joins so I am a lot confused.

TIA [/B]

$query_interred = "SELECT $interest.,$plots.,$owners.* FROM $interred LEFT JOIN $plots ON $interred.PlotID=$plots.ID LEFT JOIN $own ON $interred.OwnerID=$owners.ID";

Now if they have the same new fields like title.. they will over lap so you would have to use the AS like:

$owner.title AS ownerTitle

run2web

Thank you Rayn,

I will give this a try and hopefully I won't run into any that overlap where they shouldn't. I don't think there are any other than ID and I can work around that because it is an auto_incrementing number that I don't allow the user to access anyway.