PHP + MySQL - Joins query problem

[Terminator]

I have a site wich uses PHP + MySQL
Now I want to create a search page wich will search a table, but I get a error message

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sitename/public_html/cdvd/us/searchitem.php on line 228
Title Genre Region Disc Username

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/sitename/public_html/cdvd/us/searchitem.php on line 239

The database structure is below.

And here is the query

$querysearch = "SELECT * FROM CDVD RIGHT JOIN (CDVD LEFT JOIN CDVDGENRE ON CDVD.GNEREID = CDVDGENRE.GNEREID) 
ON USER.USERID = CDVD.USERID WHERE cdvd.title LIKE '% $keyword%' OR cdvd.description LIKE '%$keyword%'"; 

The thing is, I want to search in CDVD table and show the result with the username from USER table and genre from CDVDGENRE
instead of the userid and the genreid from CDVD table.

But I can't get the query working...

[bad76]

Hi,
in this cases you have to get the return error from mysql:

mysql_query($myquery) or die(mysql_error()." :<br>".$myquery);

This will give you all info you need.
see you

[Terminator]

Not unique table/alias: 'cdvd'

This is the error message I get..
As I am a complete noob with complex? mySQL statements