Return number of items in a table with post id

Question

I am trying to return the number of reviews for a given page id, I have this so far...

<?php
global $wpdb;
$countreviews = $wpdb->get_var($wpdb->prepare("SELECT COUNT(ID) FROM $wpdb->wpcreviews     WHERE page_id = ID"));
echo 'Number Of Reviews ' . $countreviews . '';
?>

Its not working and I assume its the end part page_id = ID

How do I change the ending to that it searches the wpcreviews table for items with the current page ID, which is the same as my post id?

Answer 1

$countreviews = $wpdb->get_var( $wpdb->prepare( 'SELECT COUNT(ID) FROM ' . $wpdb->prefix . 'wpcreviews WHERE page_id = %d', get_the_ID() ) );