$getaid = $db->sql_query("select event_id, user_id, event_date FROM cms_cpgnucalendar_user_on_event where user_id = '".$userinfo['user_id']."' GROUP BY event_id ORDER BY event_id DESC LIMIT $length");

$getaid = $db->sql_query("select event_id, user_id, event_date FROM cms_cpgnucalendar_user_on_event where user_id = '".$userinfo['user_id']."' GROUP BY event_date ORDER BY event_date ASC LIMIT $length");