How to display the following query

Question

Please help how can I display the result of this query:

SELECT COUNT( * ) 
FROM k1nuf_chronoengine_chronoforms_datatable_Registro_llamadas
WHERE created >= CURDATE( ) 
AND user_id =68

Thanks for your help

GreyHead · Accepted Answer

Hi angelmorales,

Sorry but I don't know what you mean by "I would like to display the line of the results"?

You can't just paste a MySQL query in the Header box and expect it to do anything - it will just be treated as plain text and displayed.

<?php
$db = JFactory::getDBO();
$query = "
  SELECT COUNT( * ) 
    FROM `#__chronoengine_chronoforms_datatable_Registro_llamadas`
      WHERE `created` >= CURDATE() AND `user_id` = 68 ;
";
$db->setQuery($query);
$count = $db->loadResult();
echo $count;
?>

Bob