Re: PHP+MySQL multiple queries m.m.

From	Arne Vajhøj <arne@vajhoej.dk>
Newsgroups	dk.edb.internet.webdesign.serverside.php
Subject	Re: PHP+MySQL multiple queries m.m.
Date	2019-10-07 19:26 -0400
Organization	Aioe.org NNTP Server
Message-ID	<qnghih$1ov0$1@gioia.aioe.org> (permalink)
References	<5d976a22$0$700$14726298@news.sunsite.dk> <qnbj9u$182h$1@gioia.aioe.org> <5d99aaad$0$699$14726298@news.sunsite.dk> <20191006120036.0db1fe8238166713b3210cca@gmail.com>

Show all headers | View raw

On 10/6/2019 6:00 AM, Jan Hansen wrote:
> Dennis Munding skrev:
> ...
>>> typ,name,2*365-DATEDIFF(NOW(),start) AS missingdays FROM members
> ...
> 
>> Det er lige netop sådan et kald, jeg er på udkig efter, omend mine
>> "datoer" er indsat som timestamps i stedet for, da jeg synes, det er
>> nemmere at arbejde med.
>> Jeg vil straks gå i gang med at "lege" med dit forslag.
> 
> Sådan noget mysql har da også en modulo funktion,
> <https://www.w3schools.com/sql/func_mysql_mod.asp>
> så det må vel være til at finde dem, der holder N*500 dages
> jubilæum indenfor næste uge, med noget i stil med
> 
> SELECT * FROM tabel WHERE MOD(DATEDIFF(NOW(),indmeldt),500) > 493

Hvis det kun er multipla af 500, så kan man bruge noget a la
(jeg bruger 365 i.s.f. 500 men ...):

mysql> SELECT ((DATEDIFF(NOW(),start) + 7) DIV 365) AS years,name,(365 - 
DATEDIFF(NOW(),start) % 365) AS missingdays FROM members WHERE 
DATEDIFF(NOW(),start) % 365 BETWEEN 365-7 AND 365 ORDER BY missingdays;
+-------+------+-------------+
| years | name | missingdays |
+-------+------+-------------+
|     2 | C C  |           1 |
|     1 | A A  |           2 |
+-------+------+-------------+
2 rows in set (0.00 sec)

Arne

Back to dk.edb.internet.webdesign.serverside.php | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-04 15:49 +0000
  Re: PHP+MySQL multiple queries m.m. Jan Hansen <jhjjhjhhansen@gmail.com> - 2019-10-05 00:28 +0200
    Re: PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-05 10:24 +0000
  Re: PHP+MySQL multiple queries m.m. Arne Vajhøj <arne@vajhoej.dk> - 2019-10-05 22:25 -0400
    Re: PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-06 08:49 +0000
      Re: PHP+MySQL multiple queries m.m. Jan Hansen <jhjjhjhhansen@gmail.com> - 2019-10-06 12:00 +0200
        Re: PHP+MySQL multiple queries m.m. Arne Vajhøj <arne@vajhoej.dk> - 2019-10-07 19:26 -0400
          Re: PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-08 08:35 +0000
            Re: PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-08 09:05 +0000
            Re: PHP+MySQL multiple queries m.m. Arne Vajhøj <arne@vajhoej.dk> - 2019-10-08 19:58 -0400
              Re: PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-09 09:22 +0000
                Re: PHP+MySQL multiple queries m.m. Kim Ludvigsen <kim@kimsside.dk> - 2019-10-09 16:36 +0700
                Re: PHP+MySQL multiple queries m.m. Bertel Lund Hansen <gadekryds@lundhansen.dk> - 2019-10-09 11:56 +0200
                Re: PHP+MySQL multiple queries m.m. Bertel Lund Hansen <gadekryds@lundhansen.dk> - 2019-10-09 11:58 +0200
                Re: PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-09 10:49 +0000
            Re: PHP+MySQL multiple queries m.m. Jan Hansen <jhjjhjhhansen@gmail.com> - 2019-10-08 20:12 +0200
  Re: PHP+MySQL multiple queries m.m. "Dennis Munding" <nospa@mplease.dk> - 2019-10-06 10:57 +0000

csiph-web