Path: csiph.com!news.mixmin.net!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: Tue, 8 Oct 2019 20:12:31 +0200
Organization: A noiseless patient Spider
Lines: 32
Message-ID: <20191008201231.b00607f35bb37f96575fdc68@gmail.com>
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> <qnghih$1ov0$1@gioia.aioe.org> <5d9c4a5e$0$705$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="c4438c26df75438964b9a48c121b5782"; logging-data="5357"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+ZyJrbp0rDLEASSX5qxsGSY6mgFZpEQWw="
User-Agent: Sylfide for Fedora (sylpheed.sraoss.jp)
Cancel-Lock: sha1:x4qcf1k+85H4jnFupOtZH0RPvyQ=
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:7213

Dennis Munding skrev:

> Arne Vajhøj wrote:

> > 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)
> 
> 
> Jeg har så brug for at søge efter alle indekstal (1000, 1500, 2000,
> 2500 & 3000).

Det er vel ikke så slemt. Hvis start er inmeldelsestidspunktet lavet med 
php's time funktion, skal NOW() vel bare skiftes ud med et tilsvarende 
php-tal, og så dele med sekunder pr. døgn. Dvs DATEDIFF(NOW(),start) skal 
udskiftes med ($phpnutid-start)/86400, så passer resten. 
Hvis du ikke vil have 500 dages jubilæum med, skal der nok bare trækkes 500 
dage fra.



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