help! code!

[Anon]

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!
:-)

[Anon]

did u use mysql_connect to connect to ur database before using mysql_query.

[Anon]

yep, it connects just fine... but for some reason, whatever variable i put in the place of where $result is, the script errors.

[Anon]

Here is the full code for the page:

<?php
$connection= @mysql_connect ("localhost", "westerly", "k47UhFYM");
if (!$connection) {
echo( "<P>Unable to connect to " .
"database server at this time.</P>" );
exit();
}

mysql_select_db("westerly_com", $connection);
if (! @mysql_select_db("westerly_com") ) {
echo( "<P>Unable to locate information " .
"database at this time.</P>" );
exit();
}
?>

<?php
$goal = mysql_query("INSERT INTO AutoInformation (CarYear, CarMake, CarModel) VALUES ('$CarYear', '$CarMake', '$CarModel');
?>

<P>Your insurance quote is approximately: </P>

<BLOCKQUOTE>

<?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");

// Display the text of insurance rate
while ( $row = mysql_fetch_array($result) ) {
echo("<P>" .
$row["InsuranceRate"] . "
</P>");
}
?>

</BLOCKQUOTE>
dollars per month. This rate is estimated. <br>
You should fill out a full quote form for a <br>
more accurate insurance quote.

[Anon]

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

Try this Instead
while ( $row = mysql_fetch_array($result) ) {
$rate = $row["InsuranceRate"] ;
echo("<P>$rate</P>");
}
hope that's not your password you submitted
if so you may want to change it?
good day
gd

[Anon]

I'm new to PHP! I won a sertan page to be redirected to index.html,if it is not reguested from te link that I have on the index.html.

[Anon]

hehe, don't worry, it was dummy info....

thanks for the help, but unfortunately i'm still getting the same error; it doesn't like the query beginning with ("SELECT InsuranceRate
I'm still not sure why...
Thanks though :-)

[Anon]

kathy<?php
$goal = mysql_query("INSERT INTO AutoInformation (CarYear, CarMake, CarModel) VALUES ('$CarYear', '$CarMake', '$CarModel') ");<---
?>

you need a ") at the end I believe.
good day
gd

[Anon]

THANKS that fixed that problem... but now I am getting the parse error on the very last line of the code... screams in frustration
sooo close. ;-)

[Anon]

katey
in the while loop?
good day
gd

[Anon]

the very last line in the code, except it's just text. I've looked for missing closed tags and everything but with no luck... am I missing something?

Thanks so much for taking the time to help me out!

:-) Katey

[Anon]

katey
try blocking out this code to see if it's in here using / / if runs fine then some where in here is the problem. i can't see it
<?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");

// Display the text of insurance rate
while ( $row = mysql_fetch_array($result) ) {
echo("<P>" .
$row["InsuranceRate"] . "
</P>");
}
*/
?>

[Anon]

ok, I think I've got it at least kinda working; no more parse errors. Thank you so very much for helping me out! :-)

[fleymingmasc]

A little off topic, but if I were you, I'd change my password RIGHT AWAY! Don't ever give out your real username/password in sample code.

[Anon]

as i said earlier, its dummy info, thanks though