I have the following tables: days, periods, prices
The Price model belongsTo Day and Period
$this->Price->find('all')
returns this:
<pre>Day Period Price
5 - 20 days 01 May 2011 to 31 Aug 2011 $87.00
21 to 27 01 May 2011 to 31 Aug 2011 $66.00
28+ 01 May 2011 to 31 Aug 2011 $63.00
5 - 20 days 01 Sep 2011 to 30 Sep 2011 $177.00
21 to 27 01 Sep 2011 to 30 Sep 2011 $165.00
28+ 01 Sep 2011 to 30 Sep 2011 $155.00
5 - 20 days 01 Oct 2011 to 31 Oct 2011 $322.00
21 to 27 01 Oct 2011 to 31 Oct 2011 $310.00
28+ 01 Oct 2011 to 31 Oct 2011 $300.00</pre>
How can I present the data like this?
<pre> 5 - 20 days 21 - 27 days 28+ days
01 May 2011 to 31 Aug 2011 $87.00 $66.00 $63.00
01 Sep 2011 to 30 Sep 2011 $177.00 $165.00 $155.00
01 Oct 2011 to 31 Oct 2011 $322.00 $310.00 $300.00</pre>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
