I am new to PHP and have tried to figure out what the problem is with this code I am using. It's my first MySQL query and it appears to be choking on the last line, throwing "syntax error, unexpected $end". I tried using endwhile instead of } that didn't solve it so I'm stumped. The ending ?> tag does seem to match the starting php tag so not sure what is missing. Here it is:
<?php
mysql_connect ("ratetable.db.1018.host.com", "ratetable","notmypassword") or die (mysql_error());
mysql_select_db ("rates");
$term = (int)$_POST['term'];
$sql = mysql_query("select * from 'rates' where 'mileage' <= 'term';
while ($row = mysql_fetch_array($sql)){
echo '<br/> Mileage radius:'.$row[mileage];
echo '<br/> Rate per mile:'.$row[ratepermile];
echo '<br/><br/>';
}
?>
I saw one post where someone enabled short tags to on in php.ini and I added that as a precaution (wasn't already there) but didn't do anything. I'm drawing a blank about why it's not liking the last line.
Thank you for having a look.