so i add model and i hvae 2nd problem
now
" DESC `login_attempts` 4 4 1
5 DELETE FROM WHERE expire <= NOW() OR ( UNIX_TIMESTAMP(created) >
UNIX_TIMESTAMP(NOW()) - 120 ) 1064: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'WHERE expire <= NOW() OR (
UNIX_TIMESTAMP(created) > UNIX_TIMESTAMP(NOW()) - 120' at line 1
0
6 SELECT `LoginAttempt`.`ip`, `LoginAttempt`.`num`,
`LoginAttempt`.`expire`, `LoginAttempt`.`created` FROM `login_attempts`
AS `LoginAttempt` WHERE (`LoginAttempt`.`ip` = '83.20.216.21') LIMIT 1"
so i suggest change
useTable to
login_attempts
$del_sql = "DELETE FROM {$Model->useTable} WH
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
