anonīms Posted April 12, 2009 Author Report 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
Aleksejs Posted April 12, 2009 Report 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
shepp Posted April 13, 2009 Report 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
anonīms Posted April 13, 2009 Author Report Posted April 13, 2009 id(int) | datums(datetime) | ip(int) Quote
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.