Pulling Data From Multi tables help

[m1k3]

Hi again.

Okay im onto working out how i can pull back the info i have entered into the database.

I have 4 tables

Auto
Dimensions

Ratios
Specs

I have a specifications for a car called Honda Civic in the database that's accross those 4 tables. Im now wanting to pull all the info for the Honda Civic and im a little stuck 🙁 They all have an ID called autoid but i dunno if i need that.

Here is what code i have so far, if somone could tell me where im going wrong i would be very greatfull.

<?

// Set Mysql Variables
$host = 'host'; 
$user = 'user';
$pass = 'pass';
$db = 'database'; 


$con= mysql_connect($host,$user,$pass);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db($db,$con);


$result= mysql_query("SELECT * FROM auto, dimensions, ratios, specs
WHERE make = 'Honda' AND model = 'celica' ");
if (!$result) { 
echo("<p>Error performing query: " . mysql_error() . 
"</p>"); 
exit(); 
} 

while ( $row = mysql_fetch_array($result) ) { 
echo ($row); 
}
?>

[leatherback]

$result= mysql_query("SELECT * FROM auto, dimensions, ratios, specs
WHERE make = 'Honda' AND model = 'celica' ");

Is where you go wrong:

The database is not aware of the relation between these tables. You need to tell it, e.g., :

$result= mysql_query("SELECT * FROM auto
left join dimensions on auto.id = dimensions.autoid
left join ratios on auto.id = ratios.autoid
left join specs on auto.id = specs.autoid
WHERE make = 'Honda' AND model = 'celica' ");