[ppiper]

Hi Steven,
I have now.
The restaurant page with the comment on :
http://www.restaurantsintheminervois.co....garole.php
it has a four star rating comment on
on the database (when I go to edit comment it has listed "4 - Good")
On the village page
http://www.restaurantsintheminervois.co..../aigne.php
it has the query on the page name is as it is on DB.
But only default "waiting for a star rating" is displayed.
Thanks for you help
Peter

[Steven]

Hi,

You have to use the numeric version of the page_id. You can find it in the ID column in Manage -> Pages. In your case the value is 4. So your SQL query should be:

$query = mysql_query("SELECT MAX(rating) AS highest_rating FROM comments WHERE is_approved = '1' AND page_id = '4'");

[ppiper]

Hi Steven,
It all works as it should, great!
Thanks for your help I really needed it.
Peter

[ppiper]

Hi,
what would be the sql reference for the "custom id" column

thanks for your help
Peter

[ppiper]

Hi
OK I see this column is not in the comments table so it cannot be referenced in my query.
thanks
Peter