Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail From: Jan Hansen 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> References: <5d976a22$0$700$14726298@news.sunsite.dk> <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 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, 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!