Insert in one table and update in another table

[Subrata Mukherjee]

I have two different tables say 'Student' and 'Result' with fields named 'ID' and 'Declared' in Student and 'ID' and 'Marks' in Result.

I wish to Insert the 95 as Marks in the ID number 5 also wish to Update 'Done' as in 'Declared' in 'Student'

I used the below code:

.
.
.
.

else{
$sql = "INSERT INTO Result (ID,Marks,..) values ('$ID','$marks',..);";
$sql.= "UPDATE Students SET Declared='Done' WHERE ID ='$ID'";


if($conn->query($sql)){
.
.
.

Please someone correct my code or suggest otherwise.