[RESOLVED] Parse error: syntax error, unexpected T_STRING

awais

<?PHP

$course = "";
$semister = "";
$errorMessage = "";
$num_rows = 0;



if ($_SERVER['REQUEST_METHOD'] == 'POST'){
	$course = $_POST['course'];
	$semister = $_POST['semister'];


$user_name = "root";
$pass_word = "";
$database = "attendance_system";
$server = "127.0.0.1";

$db_handle = mysql_connect($server, $user_name, $pass_word);
$db_found = mysql_select_db($database, $db_handle);


if ($db_found) {


	$SQL = "SELECT * FROM course_semister WHERE  course= $course AND semister= $semister ;
	$result = mysql_query($SQL);
	$num_rows = mysql_num_rows($result);



	if ($result) {
		if ($num_rows > 0) {
			print "ok";
		}
		else {
			print "this is not your class";
		}	
	}
	else {
		$errorMessage = "please enter again";
	}

mysql_close($db_handle);

}

else {
	$errorMessage = "Error logging on";
}

}


?>

<html>
<body>  

<div align="center">
<form name="input" action="attendance_system.html" method="post">


<table width="413" border="0">
    <tr>
     <td height="39">Course</td> 
    <td width="265"><select name="course">
    <option value="select">Select-Course</option>
    <option value="BE-ME">BE-ME</option>
    <option value="BE-EE">BE-EE</option>
    <option value="BE-IME">BE-IME</option></select>
    </td>
    <td>Semister</td>
    <td>
    <select name="semister">
    <option value="select">Select-Semister</option>
    <option value="1">Ist</option>
    <option value="2">2nd</option>
    <option value="3">3rd</option>
    <option value="4">4th</option>
    <option value="5">5th</option>
    <option value="6">6th</option>
    <option value="7">7th</option>
    <option value="8">8th</option>
	</select>
	</td>
    </tr>
  </table>

<p align="center"><input type="submit" value="OK"/></p>

</form>

</div>
</body>
</html>

Derokorian

Never closed the string on this line:

		$SQL = "SELECT * FROM course_semister WHERE  course= $course AND semister= $semister ;

awais

thanks alot for this
can u plz help me how to verify values selected from drop down list with the database....

awais

Derokorian;11001104 wrote:
Never closed the string on this line:
		$SQL = "SELECT * FROM course_semister WHERE  course= $course AND semister= $semister ;

thanks
can you help me out in selecting option from a drop down list and then verifying it with a database

Weedpacket

It would be better if you asked this as a new question in a new thread.