= 3.0";
else if ($gparad == 'belowmin')
$query .= " AND average < 2.0";
}
// Execute the query
$result = mysql_query($query);
if (!$result)
{
print "Error: the query could not be executed.";
$error = mysql_error();
print "" . $error . "
";
exit;
}
print (" The query is:
");
print ("" . $query . "
");
print (" Results of your query:
");
// Display the results in a table
print "";
print "";
print "| Student Name | ";
print "Grade Point Average | ";
print "Major | ";
print "
";
while ($row = mysql_fetch_row($result))
{
print "";
foreach ($row as $data)
{
print "| $data | ";
}
print "
";
}
print "
";
print "" . mysql_num_rows($result) . " row(s) in set.";
// Close connection
mysql_close();
?>