Zitat von Luigi Rosa lists@luigirosa.com:
Gedalya wrote on 18/10/2014 17:36:
The code looks at shared/$last_login_key, so shared/last-login/username, but your map says /shared/last-login/$user, note the leading slash! That's probably all it is.
BINGO!
Now that we killed the mosters of this level, let's move to the next
level.....Welcome to the SQL query level!
I was expecting an UPDATE...WHERE but I got this:
INSERT INTO mailbox (lastlogin,username) VALUES ('1413647370','username') ON DUPLICATE KEY UPDATE lastlogin='1413647370'
This is not very useful if I want a
lastloginfield of themailboxtable updated on every login.Ciao, luigi
/ +--[Luigi Rosa]-- \
For every human problem, there is a neat, simple solution; and it is always wrong.
anybody knows how this can be achieved with postgresql, because 'ON
DUPLICATE KEY UPDATE' syntax is mysql specific