[RESOLVED] Help with a query

[Mark_Nordstrom]

SELECT Attendance.event AS ev, Attendance.date, Event_List.point AS pt, Sum( 
IF (
`name` = '$character', 1, 0
) ) AS Attended
FROM Attendance 
RIGHT JOIN Event_List ON Attendance.event = Event_List.event
WHERE Event_List.date > (CURDATE() - INTERVAL 2 MONTH)
GROUP BY Attendance.event, Attendance.date
ORDER BY Attendance.date DESC

OK. This statement works perfectly how I want it to. What i wanna know is there anyway to make it show every 1 as Yes and every 0 as no in php ?

[Mark_Nordstrom]

I figured it out guys thanks. I added <?php
if ($row_att['Attended'] == "1") {
echo "Yes";
} else {
echo "No";
}
?> in the code that generates the table.