i have two tables named student and qualification.
I inserted the data in student table.
Now i want to insert data in qualification table based on id generated in student table.
I tried to write my queries in such a way
$sql = "INSERT INTO student (name,fathername,degreetitle)
$sql_combine = "SELECT user_id FROM student WHERE fathername = $fathername";
$sql1 = "INSERT INTO information (user_id,cell,email)
if(mysqli_query($conn, $sql) && mysqli_query($conn, $sql1) && mysqli_query($conn, $sql_combine))
Why isn't this working?