help! code!

admin

Administrator
Staff member
Having trouble with some code; I'm new to PHP and SQL, so thanks for bearing with me...

I have the following code:

<?php
$result = mysql_query("SELECT InsuranceRate
FROM Year_Rates, AutoInformation, CarRatings
WHERE AutoInformation.CarMake=CarRatings.CarMake
AND AutoInformation.CarModel=CarRatings.CarModel
AND CarRatings.CarRating=Year_Rates.CarRating
AND Year_Rates.CarYear=AutoInformation.CarYear");

while ( $row = mysql_fetch_array($result) ) {
echo("<P>" .
$row["InsuranceRate"] . "
</P>");
}
?>

and i keep getting a message saying that there is a parse error in the line that begins with $result.

tia for any help you could give me!
:-)
 
Back
Top