gistfile1.php

<?php
$query = $select 
 .COURSEFINDER_TABLE.".id, 
 ".COURSEFINDER_TABLE.".type, 
 ".COURSEFINDER_TABLE.".programTitle, 
 ".COURSEFINDER_TABLE.".UCAScode, 
 ".COURSEFINDER_TABLE.".adminID,
 ".COURSEFINDER_METADATA_TABLE.".subject,
 ".COURSEFINDER_METADATA_TABLE.".description " .
 "FROM ".COURSEFINDER_TABLE." " .
 "RIGHT JOIN ".COURSEFINDER_METADATA_TABLE." " .
 "ON ".COURSEFINDER_TABLE.".id = ".COURSEFINDER_METADATA_TABLE.".itemID " .
 "WHERE ".COURSEFINDER_TABLE.".term = '$term' " . 
 "AND ( programTitle REGEXP '".
 "AdvDip[[:space:]]$searchQuery|".
 "BA[[:space:]]$searchQuery|".
 "BA/BSc[[:space:]]$searchQuery|".
 "BChD[[:space:]]$searchQuery|".
 "BDes[[:space:]]$searchQuery|".
 "BEng[[:space:]]$searchQuery|".
 "BEng/MEng[[:space:]]$searchQuery|".
 "BHSc[[:space:]]$searchQuery|".
 "BMC[[:space:]]$searchQuery|".
 "BME[[:space:]]$searchQuery|".
 "BMP[[:space:]]$searchQuery|".
 "BMus[[:space:]]$searchQuery|".
 "BSc[[:space:]]$searchQuery|".
 "BSc/MMath[[:space:]]$searchQuery|".
 "CEC[[:space:]]$searchQuery|".
 "CertHE[[:space:]]$searchQuery|".
 "Certificate in[[:space:]]$searchQuery|".
 "CET[[:space:]]$searchQuery|".
 "DipHE[[:space:]]$searchQuery|".
 "Diploma in[[:space:]]$searchQuery|".
 "Foundation Course In[[:space:]]$searchQuery|".
 "Foundation Degree:[[:space:]]$searchQuery|".
 "GradDip[[:space:]]$searchQuery|".
 "Graduate Diploma in[[:space:]]$searchQuery|".
 "IMPRESS Higher Education Certificate in[[:space:]]$searchQuery|".
 "Integrated PhD with Masters in[[:space:]]$searchQuery|".
 "Intercalated BA in[[:space:]]$searchQuery|".
 "Intercalated BSc in[[:space:]]$searchQuery|".
 "International Foundation Year:[[:space:]]$searchQuery|".
 "LLB[[:space:]]$searchQuery|".
 "LLM[[:space:]]$searchQuery|".
 "MA[[:space:]]$searchQuery|".
 "Master of[[:space:]]$searchQuery|".
 "MBA[[:space:]]$searchQuery|".
 "MBChB[[:space:]]$searchQuery|".
 "MChem[[:space:]]$searchQuery|".
 "MChem, BSc[[:space:]]$searchQuery|".
 "MDentSci[[:space:]]$searchQuery|".
 "MDes[[:space:]]$searchQuery|".
 "MDes, BDes[[:space:]]$searchQuery|".
 "MEd[[:space:]]$searchQuery|".
 "MEng[[:space:]]$searchQuery|".
 "MEng, BSc[[:space:]]$searchQuery|".
 "MEng, BEng[[:space:]]$searchQuery|".
 "MEnv, BA[[:space:]]$searchQuery|".
 "MEnv, BSc[[:space:]]$searchQuery|".
 "MFA[[:space:]]$searchQuery|".
 "MGeog[[:space:]]$searchQuery|".
 "MGeol[[:space:]]$searchQuery|".
 "MGeol, BSc[[:space:]]$searchQuery|".
 "MGeoPhys[[:space:]]$searchQuery|".
 "MGeoPhys, BSc[[:space:]]$searchQuery|".
 "MGeoSci[[:space:]]$searchQuery|".
 "MHSc[[:space:]]$searchQuery|".
 "MMath[[:space:]]$searchQuery|".
 "MMath, BSc[[:space:]]$searchQuery|".
 "MMedSc[[:space:]]$searchQuery|".
 "MMus[[:space:]]$searchQuery|".
 "MNatSc[[:space:]]$searchQuery|".
 "MNatSc,BSc[[:space:]]$searchQuery|".
 "MNatSc/BSc[[:space:]]$searchQuery|".
 "MPH[[:space:]]$searchQuery|".
 "MPhys[[:space:]]$searchQuery|".
 "MPhys, BSc[[:space:]]$searchQuery|".
 "MPsychObs[[:space:]]$searchQuery|".
 "MRes[[:space:]]$searchQuery|".
 "MSc (Eng)[[:space:]]$searchQuery|".
 "MSc[[:space:]]$searchQuery|".
 "PG Dip[[:space:]]$searchQuery|".
 "PG Diploma[[:space:]]$searchQuery|".
 "PGCert[[:space:]]$searchQuery|".
 "PGDip[[:space:]]$searchQuery|".
 "PhD[[:space:]]$searchQuery|".
 "') " .
 $additional . " " . 
 "ORDER BY programTitle ASC";
?>