Salve a tutti
come associare questi array? nel database sono memorizzati cosi
https://www.upload.ee/image/14683761/sshot-1.png
mi interessano solo akaname e addition
questa e' la query
questo e' il whileCodice PHP:$query = "
SELECT
actors.*,
array_to_string( ARRAY_AGG ( akanames.addition ), ' *<br> ' ),
array_to_string( ARRAY_AGG ( akanames.akaname ), ' *<br> ' ) AS aka
FROM
actors
LEFT JOIN akanames ON actors.name = akanames.name
WHERE
(actors.actorid = ('$actor_id'))
GROUP BY
actors.actorid
";
$result = pg_query($query) or die('Error message: ' . pg_last_error());
Codice PHP:<?php
while ($row = pg_fetch_object($result)) {
?>
