Hi,

I basically want to use set to create a 3D array that has the
dataAcquired as the key for an array that has a bunch of machine
details in it. So I can display a table that has the date as a field
and then a long list of details.
I figured it would be easier to have an array in an array rather than a
sort because cakephp would be able to run though the array with less
code.
This is what I have at the moment are:
$this->set('dates',$this->Asset->query('SELECT DISTINCT DateAcquired
FROM inventory.assets ORDER BY DateAcquired DESC'));
foreach($dates AS $date)
{
$this->set($dates['assets']['DateAcquired'],$this->Asset->query('SELECT
DISTINCT DateAcquired FROM inventory.assets WHERE \''.$date.'\''));
}

I hope that makes it clearer..
 Shaf.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---

Reply via email to