Radicore Forum: How To » Using SQL Aggregate Functions

Home » RADICORE » How To » Using SQL Aggregate Functions (How to use MAX, AVE, SUM, etc.)

Thu, 13 March 2008 07:41

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

If you look inside the _cm_getInitialData() method of file crs_student.class.inc you will see that I use the following code:

$count = $this->getCount("SELECT max(student_id) FROM $this->tablename");
$fieldarray['student_id'] = $count + 1;

I have also tried the following code with exactly the same result:

$this->sql_select = "MAX(student_id) AS last_id";
$rows=$this->getdata_raw();
$count = $rows[0]['last_id'];

I prefer the first method as it requires less code.

		Using SQL Aggregate Functions By: melvinsdb on Thu, 13 March 2008 06:58
		Re: Using SQL Aggregate Functions By: AJM on Thu, 13 March 2008 07:41
		Re: Using SQL Aggregate Functions By: melvinsdb on Tue, 25 March 2008 21:19
		Re: Using SQL Aggregate Functions By: AJM on Wed, 26 March 2008 06:20
		Re: Using SQL Aggregate Functions By: melvinsdb on Thu, 27 March 2008 02:27
		Re: Using SQL Aggregate Functions By: AJM on Thu, 27 March 2008 07:11
		Re: Using SQL Aggregate Functions By: melvinsdb on Fri, 04 April 2008 02:35
		Re: Using SQL Aggregate Functions By: AJM on Fri, 04 April 2008 05:21

Previous Topic:	creating list items
Next Topic:	How do you deploy your app?

Goto Forum:

] [

]

Current Time: Mon Nov 25 13:22:57 EST 2024

Total time taken to generate the page: 0.01087 seconds