php programming

[vthakor115]

how to left join works in mysql

[Squidge]

Should be in Mysql forum:

http://bit.ly/OFmu6N

[ome2012]

-family table
Position    Age
Dad         41
Mom         45
Daughter    17
Dog 

-food table
Meal    Position
Steak   Dad
Salad   Mom
Spinach Soup    
Tacos   Dad

[ome2012]

left join codes here.....

<?php
// Make a MySQL Connection
// Construct our join query
$query = "SELECT family.Position, food.Meal ".
 "FROM family LEFT JOIN food ".
    "ON family.Position = food.Position"; 

$result = mysql_query($query) or die(mysql_error());


// Print out the contents of each row into a table 
while($row = mysql_fetch_array($result)){
    echo $row['Position']. " - ". $row['Meal'];
    echo "<br />";
}
?>

[ome2012]

heres the output....

Dad - Steak
Dad - Tacos
Mom - Salad
Daughter -
Dog -