Skip to content

Instantly share code, notes, and snippets.

@jpadilla
Created May 14, 2011 17:24
Show Gist options
  • Save jpadilla/972408 to your computer and use it in GitHub Desktop.
Save jpadilla/972408 to your computer and use it in GitHub Desktop.
array(3) {
["query"]=>
object(Kohana_Mysqli_Result)#20 (8) {
["link:protected"]=>
object(mysqli)#21 (0) {
}
["fetch_type:protected"]=>
string(12) "fetch_object"
["return_type:protected"]=>
string(8) "stdClass"
["result:protected"]=>
object(mysqli_result)#19 (0) {
}
["insert_id:protected"]=>
NULL
["sql:protected"]=>
string(414) "
SELECT DISTINCT a.`courselesson_id`, c.`name` as course_name, b.`name` as lesson_name,
count(a.`courselesson_id`) as frequency,
b.`business`
FROM `lessoncompletions_session` AS a
JOIN `courselessons` AS b on b.`id` = a.`courselesson_id`
JOIN `courses` AS c on c.`id` = b.`course_id`
WHERE DATE(a.`completion_timestamp`) = CURDATE()
GROUP BY a.`courselesson_id`
ORDER BY a.`id` DESC
"
["current_row:protected"]=>
int(1)
["total_rows:protected"]=>
int(1)
}
["free_lessons"]=>
int(1)
["premium_lessons"]=>
int(0)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment