Search the group, this is just the way the PHP mysql connector returns
data. But try to identify your tables and fields as Cake does, maybe
that will help.
$result = $this->query("SELECT DISTINCT(SUBSTRING(`Game`.`date`,
1,10)) as `Game`.`date` FROM `games` AS `Game` WHERE `Game`.`date` >
'2006-08-01' ORDER BY `Game`.`date` DESC");
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
