Re: defining recordset according to first three digitsof code
What error message are you getting, probably in this line
$query_rs_allcourses = sprintf("SELECT * FROM courses WHERE coursecode LIKE
'$strippedcode'", GetSQLValueString($colname_rs_allcourses, "text"));
Try this:
$query_rs_allcourses = sprintf("SELECT * FROM courses WHERE coursecode LIKE
'%$strippedcode%'");
|