fossala wrote:Looks good. I wonder how many of them 469 came, got their answer then left.
Code: Select all
mysql> SELECT count(*) FROM `phpbb_users` WHERE user_lastpost_time > unix_timestamp(subdate(now(), interval 31 day)) and user_posts = 1;
+----------+
| count(*) |
+----------+
| 39 |
+----------+
1 row in set (0.02 sec)
(Maybe because I work part-time with that stuff, but yeah.)
SQL is an ugly language but it seems the same thing with regular expressions would look more confusing ...guilleguillaume wrote:Those codes confuse me
I don't even want to think about that... But then again, why would anybody do so in the first place? (Right? Right..?)7bit wrote:SQL is an ugly language but it seems the same thing with regular expressions would look more confusing ...guilleguillaume wrote:Those codes confuse me
I use SQL for my mail database, bit overkill though but it makes things easy.fruktstund wrote:I don't even want to think about that... But then again, why would anybody do so in the first place? (Right? Right..?)7bit wrote:SQL is an ugly language but it seems the same thing with regular expressions would look more confusing ...guilleguillaume wrote:Those codes confuse me
SQL is good for what it's meant for!
Oh dear, such a detail on the keyboard only to get the mouse cable wrong. Should have gone for a wireless one...scottc wrote:
Oh wow, I hadn't noticed that before... brilliant.Daniel Beardsmore wrote:I imagine it would also be a pain having the mouse cable under your wrist.
