« Project home page
my little forum
Log in
Register
Search:
Back to the entry by Auge
Post reply
Reply to the message by
Auge
Name:
E-mail:
(optional, won't be displayed directly)
Leave this field empty:
Homepage:
(optional)
Leave this field empty:
Location:
(optional)
Remember me (cookie)
Category:
General
Project organisation
Technics
Design/Themes
Features
Development
Todo
Bugs
German / Deutsch
Spanish / Español
French / Français
Accessibility/UX
Subject:
Formatting help
skip to input
format text bold
[b]bold text[/b]
format text italic
[i]italic text[/i]
insert hyperlink
[link=http://example.com/]link text[/link] / [link]http://example.com/[/link]
set text color
[color=#rgb]colored text[/color]
font size
[size=small]small text[/size]
[size=large]large text[/size]
insert list
[list][*]list item[/list]
insert image
[img]http://example.com/image.jpg[/img]
left: [img=left]http://example.com/image.jpg[/img]
right: [img=right]http://example.com/image.jpg[/img]
thumbnail: [img=thumbnail]http://example.com/image.jpg[/img]
thumbnail left: [img=thumbnail-left]http://example.com/image.jpg[/img]
thumbnail right: [img=thumbnail-right]http://example.com/image.jpg[/img]
upload image
upload image ...
insert TeX code
[tex]TeX code[/tex]
insert code
[inlinecode]code[/inlinecode]
[code]code[/code]
[code=css]code[/code]
[code=html]code[/code]
[code=javascript]code[/code]
[code=perl]code[/code]
[code=php]code[/code]
[code=sql]code[/code]
[code=xml]code[/code]
:-)
;-)
:-P
:-D
:-|
:-(
:yes:
:no:
:ok:
:lol:
:lol2:
:lol3:
:cool:
:surprised:
:angry:
:crying:
:waving:
:confused:
:lookaround:
:clap:
:love:
:tick:
Message:
> Hello > > > > In both cases I get a warning. > > > > I think, it is a auto-cast problem. > > Yes, you are right. > > > Please use the data base table instead of this query. Check out the [i]true[/i] result using > > > > [code=sql]SELECT > > `last_login`, > > (`last_login` - (NOW() - INTERVAL 3 YEAR)) > > FROM `mlf2_userdata` > > WHERE `user_lock` = 0 > > AND `user_type` = 0 > > AND `inactivity_notification` = FALSE > > ORDER BY `last_login` ASC;[/code] > > I took the query, executed it with and without the [inlinecode]user_type[/inlinecode] and with addition of the name and the (optional) addition of [inlinecode]AND `last_login` > (NOW() - INTERVAL 3 YEAR)[/inlinecode]. In every case I get the correct results. > > [b]*btw*[/b]: [i]IMHO[/i] [inlinecode]AND `last_login` > (NOW() - INTERVAL 3 YEAR)[/inlinecode] has a better readability than [inlinecode]AND (`last_login` - (NOW() - INTERVAL 3 YEAR)) < 0[/inlinecode] even both conditions work. > > Tschö, Auge
E-mail notification on reply of this posting
OK - Submit
Preview