php connection

[Vani Sweety]

hello
i have been writing this piece of code that tahkes values from a javascript file and do som orepation in php
but i am getting an error
:
Parse error: syntax error, unexpected '$Rname' (T_VARIABLE) in C:\xampp\htdocs\vehicle\reviews.php on line 18

<?php
$servername = "localhost";
$username = "root";
$password = "vani";
$dbname = "vehiclesdb";
$port = "3306";

$Rname = $_POST['id'];
$Rdate = $_POST['yr'];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname, $port);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
//retrieve data from database
$sql = "SELECT * FROM final_review1 WHERE vehicle='"$Rname"' AND year='"$Rdate"'";
$sql1 = "SELECT * FROM final_review2 WHERE vehicle='"$Rname"' AND year='"$Rdate"'";
$result = $conn->query($sql);
$result1 = $conn->query($sql1);

if ($result->num_rows > 0) {
	while($row = $result->fetch_assoc()) {
		$pos1= $row['pos'];
		$neg1 = $row['neg'];
		$tot1 = $row['total'];
		if ($result1->num_rows > 0) {
				while($row = $result1->fetch_assoc()) {
					$pos2=$row['pos'];
					$neg2 = $row['neg'];
					$tot2 = $row['total'];
					//do average ($result & $result1)
					$positive = ($pos1+$pos2)/2;
					$negative= ($neg1+$neg2)/2;
					$total= ($tot1+$tot2)/2;
					echo "<pre>";
					echo "$total";
					echo "</pre>";
					echo "<pre>";
					echo "$positive";
					echo "</pre>";
					echo "<pre>";
					echo "$negative";
					echo "</pre>";
				}
		} else{
			echo "<pre>";
			echo $tot1;
			echo "</pre>";
			echo "<pre>";
			echo $pos1;
			echo "</pre>";
			echo "<pre>";
			echo $neg1;
			echo "</pre>";
		}
	}
}
else{
	while($row = $result1->fetch_assoc()) {
		$pos2=$row['pos'];
		$neg2 = $row['neg'];
		$tot2 = $row['total'];
	//while($row = $result1->fetch_assoc()) {
		echo "<pre>";
		echo $tot2;
		echo "</pre>";
		echo "<pre>";
		echo $pos2;
		echo "</pre>";
		echo "<pre>";
		echo $neg2;
		echo "</pre>";
	//}	
	}
}
$conn->close();

?>

[Patel Maulik]

This code to use query to try this and check and replay

$sql = "SELECT * FROM final_review1 WHERE vehicle='".$Rname."' AND year='".$Rdate."'";
$sql1 = "SELECT * FROM final_review2 WHERE vehicle='".$Rname."' AND year='".$Rdate."'";