Professional Web Applications Themes

mysql simple DateAdd() problem - MySQL

Hi I need to find users who logged in to my site in the last 5 minutes. This is code i found but it aint working. Anyone know why? Select * from user where lastlogin>= '' & DateAdd("n",-5, Now()) Thanks a lot! Ciarán...

  1. #1

    Default mysql simple DateAdd() problem

    Hi I need to find users who logged in to my site in the last 5 minutes.
    This is code i found but it aint working. Anyone know why?

    Select * from user where lastlogin>= '' & DateAdd("n",-5, Now())

    Thanks a lot!
    Ciarán

    cron Guest

  2. #2

    Default Re: mysql simple DateAdd() problem

    cron wrote: 

    Since all you have told us is "it aint (SIC) working" and you haven't even
    bothered to tell us what you are actually seeing, it could be just about
    anything:
    There is no such table as user
    there is no such field as lastlogin
    you have an uneven number of quotes
    the & is not a valid symbol in whatever language you are working in
    the mysql server is not running
    you entered the string in Notepad instead of submitting it to mysql

    and many many more.

    Care to tell us a bit more about what you are seeing?


    Paul Guest

  3. #3

    Default Re: mysql simple DateAdd() problem

     

    No need to be rude! It was completely wrong:
    I figured it out: To find a user who's logged in in the last 5 minutes
    something like this works:

    SELECT * FROM user WHERE (NOW() - INTERVAL 5 MINUTE) <= lastlogin ORDER
    BY lastlogin;

    Cheers,
    Ciarán

    cron Guest

Similar Threads

  1. dummy here needs simple MySQL syntax help
    By Lossed in forum Coldfusion Database Access
    Replies: 1
    Last Post: February 10th, 03:03 AM
  2. Simple MySql into Flash problems
    By brettfade in forum Macromedia Flash Data Integration
    Replies: 4
    Last Post: July 18th, 12:33 PM
  3. Facing problem in dateadd function.
    By ufnasoft in forum Coldfusion - Getting Started
    Replies: 5
    Last Post: May 5th, 06:49 PM
  4. Mysql::Simple?
    By Brian McCauley in forum PERL Modules
    Replies: 2
    Last Post: February 1st, 06:35 PM
  5. Hep req. with PHP and MySQL - simple guestbook
    By Phlarmf in forum PHP Development
    Replies: 3
    Last Post: September 21st, 08:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139