Re: Recursion for my own custom query?
On Jun 18, 3:03 pm, Joshua Benner [EMAIL PROTECTED] wrote: Looks good. I think I would use Cake's magic before writing my own function like that, Cake doesn't change the rules as far as DBs go. If creating an extra table model to avoid writing a GROUP BY statement with some date functions is magic, then by all means. However, considering doing that should make the hairs on the back of your neck stand up - it would generate an instant WTF from any DBA/ DB savy person upon sight ;). Cheers, AD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Recursion for my own custom query?
Consider using a 'Months' table for which you define a 'Month' model
which has associations defined between it and 'Entry'
Then:
$this-Month-findAll(array('monthName'='January'))
Pete wrote:
I have a function in my model, to get a list of the months that I have
blog entries in:
function getMonths($limit = null)
{
$sql = "SELECT DISTINCT month(Entry.date) number,
monthname(Entry.date) title, year(Entry.date) year FROM entries as
Entry ORDER BY date DESC";
if ($limit): $sql .= " LIMIT " . $limit; endif;
$result = $this-query($sql);
return $result;
}
What would be the best way to then get the Entries that are in those
months. Could I attach the Entries to those month results?
Basically, I'm trying a pretty typical "archive by month", and I'm
trying to get an array like:
[0] = Array
(
[Month] = Array
(
[number] = 5
[title] = May
[year] = 2007
)
[Entry] = Array
(
[0] = Array
(
[title] = Blog Post
[date] = May 06, 2007
)
[1] = Array
(
[title] = Blog Post
[date] = May 06, 2007
)
)
)
Any ideas?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Recursion for my own custom query?
On Jun 18, 1:55 pm, Joshua Benner [EMAIL PROTECTED] wrote:
Consider using a 'Months' table for which you define a 'Month' model which
has associations defined between it and 'Entry'
Then:
$this-Month-findAll(array('monthName'='January'))
Or not :).
http://bin.cakephp.org/saved/20574
hth,
AD
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Recursion for my own custom query?
Looks good. I think I would use Cake's magic before writing my own
function like that, though. However, the function also accomplishes
more than the initial target functionality.
AD7six wrote:
On Jun 18, 1:55 pm, Joshua Benner [EMAIL PROTECTED] wrote:
Consider using a 'Months' table for which you define a 'Month' model which has associations defined between it and 'Entry'
Then:
$this-Month-findAll(array('monthName'='January'))
Or not :).
http://bin.cakephp.org/saved/20574
hth,
AD
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Recursion for my own custom query?
I have a function in my model, to get a list of the months that I have
blog entries in:
function getMonths($limit = null)
{
$sql = SELECT DISTINCT month(Entry.date) number,
monthname(Entry.date) title, year(Entry.date) year FROM entries as
Entry ORDER BY date DESC;
if ($limit): $sql .= LIMIT . $limit; endif;
$result = $this-query($sql);
return $result;
}
What would be the best way to then get the Entries that are in those
months. Could I attach the Entries to those month results?
Basically, I'm trying a pretty typical archive by month, and I'm
trying to get an array like:
[0] = Array
(
[Month] = Array
(
[number] = 5
[title] = May
[year] = 2007
)
[Entry] = Array
(
[0] = Array
(
[title] = Blog Post
[date] = May 06, 2007
)
[1] = Array
(
[title] = Blog Post
[date] = May 06, 2007
)
)
)
Any ideas?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
