Ciao a tutti,
rieccomi con i miei complicati quesiti, per me, ma non per voi guru del codice

la discussione si chiama cosi perche' sto usando lo script

Yet Another DataTables Column Filter - (yadcf)

https://github.com/vedmack/yadcf/releases

passiamo al problema, sono riuscito a interrogare quasi tutti i dati, manca studio e distributor,
il problema risiede nella query, il campo nome viene visualizzato quasi raddoppiato,
dal conteggio in phpmyadmin risultano 622 record ma vengono estratti 1228

questa e' la query


Codice PHP:
<?php

require_once("connetti.php");

$query = " SELECT
film_actor.actor_id as actor_id,
actor.birthday as birthday,
actor.career_status as career_status,
actor.actor_id as actor_id,
actor.ethnicity as ethnicity,
actor.height as height,
actor.foto as foto,
actor.nome as nome,
actor.died as died,
actor.start as start,
actor.end as end,
film_actor.film_id as film_id,
film_actor.credited as credited,
film_actor.genre as genre,
film.film_id as film_ID,
film.movie_title as movie_title,
film.formats as formats,
film.studio as studio,
film.year as film_year,
film.also_known as also_known,
film.incollection as incollection,
film.cover_front as cover_front,
film.release_data as release_data,
film.last_update as last_update,
TIMESTAMPDIFF(YEAR,birthday,died) as age,
film.distributor as distributor
FROM film_actor
INNER JOIN film ON film_actor.film_id = film.film_id
INNER JOIN actor ON film_actor.actor_id = actor.actor_id"
;


$result = mysql_query( $query );
if (!
$result)
die(
"mySQL error: ". mysql_error());
while(
$row = mysql_fetch_object( $result ) ) : ?>
e questo e' il codice completo

https://yadi.sk/d/YU0N_nB4vENiZA