anonīms Posted April 12, 2009 Author Report Share Posted April 12, 2009 izmantoju WHERE WEEK(datums) = WEEK( NOW() ), bet tikko pamanīju vienu lietu. Lapa domā, ka tagad ir 1diena, jo statistikā šīs nedēļas statistika ir sākusies no jauna. Quote Link to comment Share on other sites More sharing options...
Aleksejs Posted April 12, 2009 Report Share Posted April 12, 2009 Izlasi par otro padodamo parametru WEEK() funkcijai: Mode First day of week Range Week 1 is the first week …0 Sunday 0-53 with a Sunday in this year 1 Monday 0-53 with more than 3 days this year 2 Sunday 1-53 with a Sunday in this year 3 Monday 1-53 with more than 3 days this year 4 Sunday 0-53 with more than 3 days this year 5 Monday 0-53 with a Monday in this year 6 Sunday 1-53 with more than 3 days this year 7 Monday 1-53 with a Monday in this year Quote Link to comment Share on other sites More sharing options...
shepp Posted April 13, 2009 Report Share Posted April 13, 2009 http://paste.php.lv/125e47dca856b6602b6015...09f76c?lang=phpŠķiet, ka sanāca :) un apmeklētāji šomēnes ar izveidoju. Viss iet ideāli. varētu lūdzu pateikt, kāda datubāze jāizveido, tas SQL kods, teksts vai kā viņu sauc? ;) Quote Link to comment Share on other sites More sharing options...
anonīms Posted April 13, 2009 Author Report Share Posted April 13, 2009 id(int) | datums(datetime) | ip(int) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.