Re: PHP+MySQL multiple queries m.m.

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From	Jan Hansen <jhjjhjhhansen@gmail.com>
Newsgroups	dk.edb.internet.webdesign.serverside.php
Subject	Re: PHP+MySQL multiple queries m.m.
Date	Sun, 6 Oct 2019 12:00:36 +0200
Organization	A noiseless patient Spider
Lines	25
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>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Info	reader02.eternal-september.org; posting-host="96bafa1d6c4e38094d78ba7791de4e84"; logging-data="9810"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1930U4ER4yTTo/zHlGLhF1QjBuUiEbJypY="
User-Agent	Sylfide for Fedora (sylpheed.sraoss.jp)
Cancel-Lock	sha1:f0No9vsutHpio+2SSAKXz12JQS8=
face	iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAMAAABg3Am1AAAAM1BMVEVAAAAEAgccGRcrKytDLQd pRQVKTEyPYw5naGazfQTNlQi3mFehnZfxuADsyBPLzMn6/PhA/qUdAAAAAXRSTlMAQObYZgAAAA FiS0dEAIgFHUgAAAAJcEhZcwAACxMAAAsTAQCanBgAAAAHdElNRQfgAg8RLTjt/9kiAAABlklEQVRIx7WV27qEIAiFB80TI+H7P+0Gm4OWTXax+bqi9csSjR6PccDjTsArburtLPFeP/pJ4g1YM+cKuvgfwKsZG/2sJV9Y9FyKnwSyZQ+R9ZkDojbURwCeruCI8GlqhQkCbCJaJchNAg6rfl3xHoCYZi0FFDHiM8thTBDgWYiUMrOBaKYAzk+Rl8Izt0PaX1ijlO2s4UqfRbjJS8nXJcCUNi6vrFzVDrAXhH6Y6qY60o3kayA36wvhwf4gQBrfORIEwPwEuOwi2h/DAPYFtIappk5uEZQjANXUiSN/BAqc7kLyeQCY086eAmYM6Gzke0AdRkfAnFlCMgNLbLbRP9LTgKC1AgYPepktMo1g31hZRIG0HlevEXb7YEnJrmWy9cBbXw1we/ekakpJFxwDJLPItIBIcas/tkSrzMf2rn7f0Bggio0lv7RvaAzg15CFDsC+pZ+0ey8v7XQ40ncFCIP8TaLf5sUHwO7kpG+IDfCNF4DpcNAhBMVU71pAjwBTGH/STqHglia1SCaFcD75nHN9Ytln/gB2JSmlFxN3ggAAAABJRU5ErkJggg==
X-Newsreader	Sylpheed 3.7.0 (GTK+ 2.24.27; x86_64-unknown-linux-gnu)
Xref	csiph.com dk.edb.internet.webdesign.serverside.php:7207

Show key headers only | 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