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?
Greetz,
Bob
<code>
$result = $this->query("SELECT DISTINCT(SUBSTRING(date,1,10)) as date
FROM games WHERE date > '2006-08-01' ORDER BY date DESC");
print_r($result);
</code>
<result>
Array
(
[0] => Array
(
[#sql_4d2c_0] => Array
(
[date] => 2007-05-05
)
)
[1] => Array
(
[#sql_4d2c_0] => Array
(
[date] => 2007-03-10
)
)
[2] => Array
(
[#sql_4d2c_0] => Array
(
[date] => 2007-02-20
)
)
)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
