I write this code using mysqli_multi_query function but when I run it no output. I don not know what is the problem , I want to run multi query in this code. Can you tell me what is the problem ?
<html>
<head>
<title> trans </title>
<body>
<?php
session_start();
$con = mysqli_connect('localhost', 'root', '');
if(!$con)
{
die("not ok");
}
mysqli_select_db($con,"uoh");
$q = " SELECT course.crd,student_record.course,student_record.grade,
student_record.term FROM course INNER JOIN student_record
ON course.course_number = student_record.course_number
WHERE student_record.id = " . $_SESSION['user_id'];
$q .= "SELECT SUM(points)FROM student_record WHERE student_record.id = " . $_SESSION['user_id'];
if (mysqli_multi_query($con, $q)) {
do {
if ($result = mysqli_store_result($con)) {
while ($row = mysqli_fetch_array($result))
{
echo $row["course"];
echo $row["grade"];
echo $row["crd"];
echo $row['term'];
}
mysqli_free_result($result);
}
} while (mysqli_next_result($con));
}
?>
</body>
</html>