If … Then …

PHP Code:

SELECT
    if 
        ASCII(tests.reading_level1) > 65
    THEN
        value = ASCII(tests.reading_level1);
    ELSE
        value = 0;
    END IF;
FROM
    report_roster
LEFT JOIN tests ON
    tests.student_id = report_roster.student_id 

MySQL is complaining that there is an error before […]

Original post by epanagio