listData() friendly input from an SQL query


I have this sql query:


        $sql='SELECT DISTINCT f.film_id, title

              FROM tbl_film AS f

              INNER JOIN tbl_showing AS s

              ON f.film_id=s.film_id

              WHERE s.start_date = :startdate

              ORDER BY title ASC;';






And want the output to be used in this:


Anyone know who I could change the format of what’s outputted so listData function will accept it.

Please help, thanks.

Solved. I wasn’t using queryAll, just queryRow

Updated post and fixed.