Php

Question

function studentSectionAvailableList($studentId, $currentSemester)
{
global $conn;
$sql="SELECT s.section_id, c.course_code, c.course_name, s.section_number".
"FROM Section s, Course c ".
"WHERE s.section_id NOT IN (
SELECT s.section_id ".
"FROM Student_Section ss, Section s ".
" WHERE ss.section_id = s.section_id ".
" AND ss.student_id = 's001')".
AND s.course_code IN (
"SELECT s.course_code ".
"FROM Student_Section ss, Section s ".
" WHERE ss.section_id = s.section_id".
" AND ss.student_id = 's001')".
"AND s.course_code = c.course_code".
"AND s.semester_id = 53";

$result = mysqli_query($conn,$sql) or
die("Error in query: $query". mysqli_error($conn));

while(($section = mysqli_fetch_assoc($result))) {
$sid = $section['section_id'];
$cc = $section['course_code'];
$cn = $section['course_name'];
$sn = $section['section_number'];

echo "<option value='$sid'>$cc - $cn (# $sn)</option>";
}

Answer 1

Use html instead of PHP

Answer 2

Ahmed thanks!

Answer 3

Hi can i ask? Which of the following is the correct syntax for a while statement? can you provide your stand of choice.

a. while ($1 <= 5, ++$i){
$echo "<p>I</p>";
}

b. while ($i <= 5){
$echo "<p>$i</p>";
++$i;
}

c. while ($i <= 5){
$echo "<p>$i</p>";
++$i:
}

d. while ($i <= 5; echo "<p>$i</p>");
++$i;
}

Answer 4

https://www.sololearn.com/Discuss/2888627/?ref=app