MySQL JOIN tables

[timmah1]

Hello,

I'm trying to join two different tables to pull out results.

This is the code that I have.

$driverID = '5';
// Make a MySQL Connection
// Construct our join query
$query = "SELECT drivers.driverID, friends.friendID, friends.driverID, friends.approved ".
"FROM drivers, friends ".
"WHERE drivers.driverID = '$driverID' OR friends.friendID = '$driverID'"; 

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

// Print out the contents of each row into a table 
while($row = mysql_fetch_array($result)){
if ($row['approved']=='y'){
echo $row['driverID']. " - ". $row['friendID'];
echo "<br />";
}
}

It should display:

5 - 169708629

169708629 - 5

 

But instead, it displays this:

5 - 169708629

169708629 - 5

169708629 - 5

169708629 - 5

 

Is there any reason why?

[londonjustin]

You might have more luck with this in the mysql forum, but in the meantime try a LEFT JOIN - post back if you need a hand with the structure.

 

J

[timmah1]

Thanks J

 

I figured it out, I was using

while($row = mysql_fetch_array($result)){

 

but when I use

$row = mysql_fetch_assoc($result);

 

It works.

 

thanks for the info