hi,
i have a query that supose to return all the classes that are taged as 'Available', but i keep getting "use of undefine constant Available" error. the same piece of coide worked befor with my last version of php and now i have upgraded to version 5.2 and i have encountered this error.
Is it something in the php.ini file i need to change? Incase its a syntax or my error here is the code
$query = "SELECT Class.ClassName, Class.StartDate, Site.SiteName
FROM Class INNER JOIN Site ON Class.SiteId = Site.SiteId
WHERE Class.ClassId='".$Classid."' AND Class.Space='".Available."';";
$result = mssql_query($query,$db) or die ("Error with Query");