mySQL Inner Join output

[ts10]

Well, this is new to me.

$getdata = mysql_query("SELECT userDownloads.download_name,userDownloads.download_timestamp,jiveUser.email FROM userDownloads INNER JOIN jiveUser ON userDownloads.download_name = jiveUser.name WHERE download_info = '$v4linux8opt_file' ORDER BY download_timestamp DESC",$db);

How do i echo out those three variables in my while loop? I seem to be able to echo out the download_name and the download_timestamp - but not the jiveUser.email

Any help? This is my first attempt with joins.

Thanks!

[nemonoman]

There's a simpler form: Try this:

SELECT
userDownloads.download_name,
userDownloads.download_timestamp,
jiveUser.email

FROM
userDownloads,
jiveUser

WHERE
userDownloads.download_name = jiveUser.name
AND
download_info = '$v4linux8opt_file'
ORDER BY
download_timestamp DESC