concatenare movie_title e year

[alex.2019]

concatenare movie_title e year

salve a tutti

ho questa query

[PHP]
$query = "SELECT
film_actor.actor_id as actor_id,
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 year,
film.incollection as incollection,
film.cover_front as cover_front,
film.release_data as release_data,
film.distributor as distributor
FROM film_actor INNER JOIN film ON film_actor.film_id = film.film_id WHERE film_actor.actor_id = " . $actor_id;

$result = mysql_query( $query );
if (!$result)
die("mySQL error: ". mysql_error());
while( $row = mysql_fetch_object( $result ) ) : ?>
[/PHP]

e questo codice

[PHP]

<img src="image_upload/movie/uploads/<?=$movie_title?> (<?=$year?>)/<?php echo $row->cover_front; ?>" width="60px" height="80px" style="border:1px solid #333333;">
[/PHP]

il problema e che devo concatenare le variabili $movie_title e ($year) (con *Brackets)

per cercare la foto nella cartella *
Exorcist (1973)/exorcist (1973).jpg
in un a query semplice dichiaro le variabili cosi
[PHP]

$movie_title=$row['movie_title'];
[/PHP][PHP]
$year=$row['year'];
[/PHP]

ma con questa query non funziona

consigli?

[alex.2019]

risolto da solo

[sermatica]

Ciao
puoi mettere la soluzione così rimane a disposizione di tutti?
Grazie