Al i'm trying to do is show an image on the product info page if the item is a bestseller. Here's my code so far that I am inserting into the tpl_product_info_display file

<?
$product_best_sellers_query = "select p.products_id
from " . TABLE_PRODUCTS . " p
where p.products_status = '1'
and p.products_ordered > 0
and p.products_id = $products_model;

if ($best_sellers_query !='') {
echo('Bestseller');
}

?>