Query help, please

[Anon]

Hi All,

Thanks for your interest in my problem.

I've posted a page with the problem:
http://www.behost.com/db/db2.htm
DB is MYSQL and i use PHP4..

BTW can you recomment some good Mysql books?
To learn query forming.
I allready have Mysql from new riders...

Kind regards,
Gerry

[Anon]

This query looks fine for getting data from 1 table:

$sql = "SELECT image_id, COUNT(*) FROM download_registratie GROUP BY image_id";
$result = mysql_query($sql);

But if I'm reading your problem correctly you want to get the image name from a second table. This should do the trick:

SELECT dr.image_id, di.name, count(dr.image_id) AS cnt
FROM download_registratie dr, download_image di
WHERE dr.image_id = di.id
GROUP BY image_id
ORDER BY cnt DESC