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
Could anyone tell me why i get a strange result with my custom query
in my model?
I would like '#sql_4d2c_0' changed to the table name, a normal with a
custom query...
In the end I need a list with al the different dates in my table,
without the time (date is a datetime cell).
Could anyone help