[PaulSonny]

Originally Posted by Dismounted

You need to loop the results to find the value, alternatively, do this instead:

PHP Code:

$counttotalproduct = $vbulletin->db->query_first("SELECT COUNT(*) AS countrows FROM " . TABLE_PREFIX . "cart_product");
$counttotalproduct = $counttotalproduct['countrows']; 


Worked an absolute treat, thanks all for help

Thanks, Paul.