echoing data from two tables joined

[holz_bee]

Hello

 

i didnt know what section to put this in but im haveing trouble echoing information

 

in my SQL part i have joined two table

 

 

where DVD.DVD_ID = REVIEW.DVD_ID

 

I want to do this on my site so i can recall the title of a dvd stored in the DVD table no the review one but i can not get it to echo ill paste you a bit of code it works without joing so my varibles are ok.

 

SELECT * FROM DVD REVIEW where DVD.DVD_ID =REVIEW.DVD_ID
and DVD.Title= '$Title'";

 

 

i want to now echo information from these tables for example customer_ID from review and DVD_Title from DVD

 

echo($row["REVIEW.Customer_ID"]);

echo($row["DVD.Title"};

 

how do i tell it what table to look in have tried various way but none work!

 

 

Thank you for your help

 

Holly

 

[per1os]

I think your sql is wrong for the first part:

 

SELECT DVD.*, REVIEW.* FROM DVD, REVIEW where DVD.DVD_ID =REVIEW.DVD_ID
and DVD.Title= '$Title'";

 

Try that and see if it works for you. Also in your second echo you are using } instead of )