heres my code

$query_atte = "SELECT Attendance.event AS ev, Attendance.date, Event_List.points 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";
$atte = mysql_query($query_atte, $db) or die(mysql_error());
$row_atte = mysql_fetch_assoc($atte);
$totalRows_atte = mysql_num_rows($atte);

This loads so dam slow 🙁 Is there anyway to clean this up to get same result but make it load quicker.

    SO HELPFUL. Thanks man i indexed my tables in mysql the page loads 10 times faster now man.

      Write a Reply...