Selecting dates next to each other in Mysql -

-

been trying figure out while now.

i looking select rows database table in mysql 2 dates next each other.

e.g. 2011-07-20 next 2011-07-21.

many thanks

neil

i guess can join using adddate():

select t1.id, t2.id mytable t1 inner join mytable t2     on t1.date = adddate(t2.date, -1) t1.id < t2.id;

the where verify t1 , t2 don't contain duplicates.


Comments

Post a Comment

Popular posts from this blog

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines. ...
Read more

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

-
i new in xmlreader, , think kind of hard find tutorials/code or advanced examples. question how can transform code have now, if search (through form) term jquery give me opportunity output value of <info></info> (and later other elements) in every <name></name> found in ? this code output names of books. <?php $reader = new xmlreader(); $reader->open("books.xml"); while ($reader->read()) { switch ($reader->nodetype) { case (xmlreader::element): if ($reader->localname == "name") { $reader->read(); echo $reader->value; break; }}} ?> the xml file <?xml version="1.0" encoding="iso-8859-1"?> <library> <book isbn="781"> <name>scjp 1.5</name> <info>sun certified java programmer book</info> </book> <bo...
Read more

c# - Global Variables vs. ASP.NET Session State -

-
this going sound rather naive, i'm developing web application spans multiple pages. of these pages instantiate same class object w/ methods accesses cms using api. currently, when user starts creating content, i'm storing variables folder id content located in session variable. my question this: can instantiate single instance of class can used across pages without having on every page? if so, each person accessing page given own version of class? assume using static variables , methods isn't way go since shared in memory. , also, where/how declared if going used globally in web application in .net c# application? i recommend making base class inherits system.page. have page code behind inherit that. then, inside base class, create property reference object. example, this: public class basepage : system.web.ui.page { public foo currentfoo { { return (foo)session["foosessionob...
Read more