I had this working and now there is no output to the page. The dropdown is empty. Can anyone see something wrong?
$sql = "SELECT spec_course.ctitle, spec_course.course_num, CONCAT(TRIM(spec_course.course_num),' - ',LEFT(spec_course.ctitle, 75)) as ccaption, spec_course.corid, spec_supplier.ctype, spec_course.online
FROM spec_course, spec_supplier
LEFT JOIN spec_supplier ON spec_supplier.supid = spec_course.supid
WHERE spec_course.supid=$supid AND spec_supplier.ctype='Technical' AND spec_course.online='Yes'
ORDER BY STATUS, spec_course.course_num";
$result = getSQLresult($sql);
$courselist = "";
while ($row = mysql_fetch_array($result)) {
$courselist =$courselist."<option value='".$row['corid']."'>".$row['ccaption']."</option>";
}
mysql_free_result($result);