Help Me with Inner Join

[haboubamix]

Hy all Programmes , Please I Have One Probleme and Idon't Now How i Can Fix it !!

I Have 2 tables in database 'web96-bouzbal'
table 1 : links



table 2 : movies


I Make this Query But not working

PHP Code:

  // -- START MYSQL LINKS MOVIES INNER JOIN -- //
                  
                  $sqlget = "select movies.id,movies.title,links.name_link,links.embed from movies left join links on movies.id_movie=link.id_movie ORDER BY id DESC WHERE id='$id'"
                  $getresult=mysql_query($sqlget);
                  
                  
                  // -- FINISH MYSQL LINKS INNER JOIN --// 


......... and Making Looping With While But not Working !!

thank you !

[sunfighter]

For one thing your missing an 'S'

$sqlget = "select movies.id,movies.title,links.name_link,links.embed from movies left join links on movies.id_movie=link.id_movie ORDER BY id DESC WHERE id='$id'"

Should be links