Re: PHP+MySQL multiple queries m.m.

From	Jan Hansen <jhjjhjhhansen@gmail.com>
Newsgroups	dk.edb.internet.webdesign.serverside.php
Subject	Re: PHP+MySQL multiple queries m.m.
Date	2019-10-06 12:00 +0200
Organization	A noiseless patient Spider
Message-ID	<20191006120036.0db1fe8238166713b3210cca@gmail.com> (permalink)
References	<5d976a22$0$700$14726298@news.sunsite.dk> <qnbj9u$182h$1@gioia.aioe.org> <5d99aaad$0$699$14726298@news.sunsite.dk>

Show all headers | View raw

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

Hvordan det skal skrives i virkeligheden, har jeg vist ikke 
så meget forstand på.

-- 
mvh Jan.
Help Microsoft stamp out piracy. Give
Linux to a friend today!

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