[eluser]Gravedigger[/eluser]
Ty Progr@mmer for help me,
i try your function, i think the pagaination was good.
The sql to, i have debug mode On.
the first one
Code:
SELECT *
FROM (`videos`)
JOIN `lien_categorie` ON `lien_categorie`.`id` = `videos`.`id_video`
WHERE `lien_categorie`.`id_categorie` = "1"
LIMIT 5
In phpMyadmin that's return good entry (9 array) and the count is good to (9):
Code:
SELECT COUNT(c.id) AS cnt FROM videos v INNER JOIN lien_categorie c ON v.id_video = c.id where c.id_categorie='1'
But i've got:GET DATA
Quote:No GET data exists
In my view i make a foreach on:
That's not return the data with an array of my first sql.
Quote:CI_DB_mysql_result Object
(
[conn_id] => Resource id #40
[result_id] => Resource id #46
[result_array] => Array
(
)
[result_object] => Array
(
)
[current_row] => 0
[num_rows] => 5
[row_data] =>
)