Update Queries

[ec]

Is it possible to have 2 update queries in the same file??  Both queries work fine with the other one // but won't work once i remove the //

 

This is the code

$qry = "SELECT level as level FROM accesslevel WHERE position= '$position' "; 
$result=mysql_query($qry);
  	$result = mysql_fetch_array($result);
$level = $result[0];

$qry = "UPDATE members SET level = '$level' WHERE teacherid = '$teacherid' ";
$result = mysql_query($qry)

$qry2 = "UPDATE teacher SET position = '$position' WHERE teacherid = '$teacherid' ";
$result2 = mysql_query($qry2);

//Check whether the queries was successful or not
if($result, $result2) {
	header("location: updatesuccessful.php");
	exit();
}else {
	die("Query failed");
}

mysql_close();

[ansarka]

check this code

 

$qry = "SELECT level as level FROM accesslevel WHERE position= '$position' "; 
$result=mysql_query($qry);
  	$result = mysql_fetch_array($result);
$level = $result[0];

$qry = "UPDATE members SET level = '$level' WHERE teacherid = '$teacherid' ";
$result = mysql_query($qry);

$qry2 = "UPDATE teacher SET position = '$position' WHERE teacherid = '$teacherid' ";
$result2 = mysql_query($qry2);

//Check whether the queries was successful or not
if($result && $result2) {
	header("location: updatesuccessful.php");
	exit();
}else {
	die("Query failed");
}

mysql_close();

[ec]

that's it...GREAT!! Thanks!