$SQL_report = "select distinct
student_id, student_name, student_address, student_gpa, college
from
SCHOOL
where MINOR = 'CS'
ORDER BY student_id";
$sth->execute;
while (@row = $sth_report->fetchrow_array) {
$student_id = (defined $row[0]) ? $row[0] : '';
$student_name = (defined $row[1]) ? $row[1] : '';
$student_address = (defined $row[2]) ? $row[2] : '';
$student_gpa = (defined $row[3]) ? $row[3] : '';
$college = (defined $row[4]) ? $row[4] : '';
## Make our html look better if no data.
$student_id = " " if ($student_id eq "");
$student_name = " " if ($student_name eq "");
$student_major = " " if ($student_address eq "");
$student_gpa = " " if ($student_gpa eq "");
$college = " " if ($college eq "");
} # End of while
####
id, name, addrss, major, gpa, college
id, name, addrss, major, gpa, college
id, name, addrss, major, gpa, college
id, name, addrss, major, gpa, college
####
BUSINESS SCHOOL
id, name, address, gpa
id, name, address, gpa
id, name, address, gpa
ENGINEERING
id, name, address, gpa
id, name, address, gpa
id, name, address, gpa
NURSING
id, name, address, gpa
id, name, address, gpa
id, name, address, gpa