php - How do I limit an already limited query? -

-

how can limit query limited?

the thing is, i'm dividing results pages, , in case, done limit (is there other way it...?), using limit again seems impossible. obviously, if have ideas on how can done in php instead (simple code, please), post it.

use offset

e.g.

[limit {[offset,] row_count | row_count offset offset}]

see select documentation

the offset calculated doing this

$offset = ($page-1) * $pagesize

the select 

select       ...          yourtable    limit        $offset, $pagesize

Comments

Post a Comment

Popular posts from this blog

iphone - Using nested NSDictionary with Picker -

-
newbie here, i have single component picker set plist, each item being array, multiple strings in each array app uses. currently plist structure this: nsdictionary -> nsarray -> nsstring | | items in picker data each item but now, want: nsdictionary -> nsdictionary -> nsarray -> nsstring | | | different picker data sets items in picker data each item so there multiple sets of picker components show using segmented control etc... i'm not sure if possible, , hoping save me making many different separate picker controllers. what has me stumped getting ingested properly this have now, builds crashes (debug info below): nsbundle *bundle = [nsbundle mainbundle]; nsstring *plistpath = [bundle pathforresource:@"camerasdatabase" oftype:@"plist"]; nsdictionary *dictionary = [[nsdictionary alloc] initwithcontentsoffi...
Read more

javascript - Iterate over array and calculate average values of array-parts -

-
i have array this: ["2011-06-16 16:37:20",23.2], ["2011-06-21 16:37:20",35.6], ["2011-06-26 16:37:20",41.8], ["2011-07-01 16:37:20",25], ["2011-07-06 16:37:20",22.8], ["2011-07-11 16:37:20",36.4], ["2011-07-16 16:37:20",34], ["2011-07-21 16:37:20",20] [...] format: [$date,count] now need add 3rd 4th value every array element, average of n counts before or after. example if n=3 the 3rd value should average of 3 count-values before , 4th value should average of 3 count-values after current array element. result that: ["2011-06-16 16:37:20",23.2, null, 34.13], ["2011-06-21 16:37:20",35.6, null, 29.86], ["2011-06-26 16:37:20",41.8, null, 28.06], ["2011-07-01 16:37:20",25, 33.53, 31.06], ["2011-07-06 16:37:20",22.8, 34.13, 30.13], ["2011-07-11 16:37:20",36.4, 29.86, null], ["2011-07-16 16:37:20",34, 28.06, null], ["2...
Read more

iphone - Pop a UIViewController containing a UITabBarController off of a UINavigationController -

-
i have uinavigationcontroller(a) pushes uiviewcontroller(b) onto stack. (b) contains uitabbarcontroller(c). (c) has 5 tabs , of these viewcontrollers(d,e,f,g,h) needs able pop (b) off stack. i've tried [[self.parentviewcontroller navigationcontroller] popviewcontrolleranimated:yes]; among many other things, none of seem work. ideas? edit: .h file: @interface matabviewcontroller : uiviewcontroller<uitabbarcontrollerdelegate> { uiviewcontroller *ref; } @property (nonatomic, retain) iboutlet uitabbarcontroller *tabbarcontroller; @property (nonatomic, retain) iboutlet uiimageview *imgviewfooter; @end .m: #import "matabviewcontroller.h" @implementation matabviewcontroller @synthesize tabbarcontroller = _tabbarcontroller; @synthesize imgviewfooter; - (void)viewdidload { [super viewdidload]; self.view = self.tabbarcontroller.view; self.tabbarcontroller.delegate = self; self.imgviewfooter.frame = cgrectmake(0.0f, 395.0f, 320.0f, 64.0f); [self.tabbarcon...
Read more