l.97 :
Le total est de 7 pour SELECT `id_film`, `titre`, `titre_original`, `genre`, `date`, DATE_FORMAT(`sortie`, '%d/%m/%Y') as `sortie`, `dvd`, `total`, `votes`, `moyenne`, `fichier`, `francais`, `url` FROM `tbl_film` WHERE `afficher` = 1 AND `realisateur` LIKE '%John Cromwell%' ORDER BY `id_film` DESC LIMIT 0, 60
Le tableau des films :Array
(
[24186] => Array
(
[id_film] => 24186
[titre] => Femmes en cage
[titre_original] => Caged
[genre] => Drame
[date] => 1950
[sortie] => 26/06/2007
[dvd] => 1
[total] => 0
[votes] => 0
[moyenne] => 0
[fichier] => femmes-en-cage.jpg
[francais] => 0
[url] => caged
)
[22582] => Array
(
[id_film] => 22582
[titre] => Abraham Lincoln
[titre_original] => Abe Lincoln in Illinois
[genre] =>
[date] => 1940
[sortie] => 00/00/0000
[dvd] => 0
[total] => 0
[votes] => 0
[moyenne] => 0
[fichier] => abraham-lincoln.jpg
[francais] => 0
[url] => abe-lincoln-in-illinois
)
[17529] => Array
(
[id_film] => 17529
[titre] => Depuis ton départ
[titre_original] => Since You Went Away
[genre] => Drame, Romance, Guerre
[date] => 1944
[sortie] => 00/00/0000
[dvd] => 0
[total] => 0
[votes] => 0
[moyenne] => 0
[fichier] => depuis-ton-depart.jpg
[francais] => 0
[url] => since-you-went-away
)
[12930] => Array
(
[id_film] => 12930
[titre] => En marge de l'enquête
[titre_original] => Dead Reckoning
[genre] => Drame, Thriller
[date] => 1947
[sortie] => 03/09/1947
[dvd] => 0
[total] => 0
[votes] => 0
[moyenne] => 0
[fichier] => en-marge-de-lenquete.jpg
[francais] => 0
[url] => dead-reckoning
)
[11335] => Array
(
[id_film] => 11335
[titre] => L'Emprise
[titre_original] => Of Human Bondage
[genre] => Drame
[date] => 1934
[sortie] => 07/04/2009
[dvd] => 1
[total] => 0
[votes] => 0
[moyenne] => 0
[fichier] => lemprise.jpg
[francais] => 0
[url] => of-human-bondage
)
[4396] => Array
(
[id_film] => 4396
[titre] => Le Petit Lord Fauntleroy
[titre_original] => Little Lord Fauntleroy
[genre] => Drame
[date] => 1936
[sortie] => 30/11/1999
[dvd] => 0
[total] => 0
[votes] => 0
[moyenne] => 0
[fichier] => le-petit-lord-fauntleroy.jpg
[francais] => 0
[url] => little-lord-fauntleroy
)
)