Good Morning...I'm a bit of a newbie to Chrono but from what I've discovered so far I think its an excellent product.
I am trying to obtain the sum a numerical column from the database and display this on the webpage in a nice neat table format. I would like to display the sum of more than one column on the same page also, somthing like the below. It would be much appreciated if someone can point me in the right direction of what query string to use and where this should be located.
Number of Lights(database column)
10 (sum of numerical values from database)
Number of Tables
25
I am trying to obtain the sum a numerical column from the database and display this on the webpage in a nice neat table format. I would like to display the sum of more than one column on the same page also, somthing like the below. It would be much appreciated if someone can point me in the right direction of what query string to use and where this should be located.
Number of Lights(database column)
10 (sum of numerical values from database)
Number of Tables
25
Hi lavelle99,
Sorry, I don't understand the question well enough to give you an answer. Please can you give a bit more info.
Bob
Sorry, I don't understand the question well enough to give you an answer. Please can you give a bit more info.
Bob
Apologies for the confusion..
The form requests that you enter the number of chairs required for that particular form. I wish then to count all the number of chairs entered in all records using chronoconnectivity?
The form requests that you enter the number of chairs required for that particular form. I wish then to count all the number of chairs entered in all records using chronoconnectivity?
Hi Lavelle99,
OK - you can do this two ways.
One is to add some code snippets to add up the chairs for each entry in the listing. It needs three parts. In the Header box
In the Body box
and in the Footer Box
The other is to add a separate MySQL query in the Header or Footer section to get the total chairs.
Bob
OK - you can do this two ways.
One is to add some code snippets to add up the chairs for each entry in the listing. It needs three parts. In the Header box
<?php
global $chairs;
$chairs = 0;
?>
In the Body box
<?php
global $chairs;
$chairs += $MyRow>chairs;
?>
and in the Footer Box
<?php
global $chairs;
echo "<div>Total chairs: $chairs</div>";
?>
The other is to add a separate MySQL query in the Header or Footer section to get the total chairs.
Bob
Hi,
Thanks for that information, it's probably the second method that I'd like to use as I don't want to display the rows on the page, I'm after a summary style page.
Can you tell me how I can do a SQL query in the Header or Footer section?
Cheers
Thanks for that information, it's probably the second method that I'd like to use as I don't want to display the rows on the page, I'm after a summary style page.
Can you tell me how I can do a SQL query in the Header or Footer section?
Cheers
Hi lavelle99,
If you don't' want the listing then you probably don't need ChronoConnectivity. Use a ChronoForm and put the MySQL query in the Form HTML instead.
Bob
If you don't' want the listing then you probably don't need ChronoConnectivity. Use a ChronoForm and put the MySQL query in the Form HTML instead.
<?php
if ( !$mainframe->isSite() ) { return; }
$db =& JFactory::getDBO();
$query = "
SELECT SUM(`chairs`) as `chair_count`, SUM(`tables`) as `table_count`
FROM `#__some_table`;
";
$db->setQuery($query);
$data = $db->loadObject();
echo "<div>Number of chairs: ".$data->chair_count."</div>";
echo "<div>Number of tables: ".$data->table_count."</div>";
?>
Bob
This topic is locked and no more replies can be posted.