Stanislav,
pls. see below text.
I tried render_table and render sql, but it seems that LIMIT always 0,30 even if I scrolled the grid.
====================================
Log started, 19/04/2014 09:04:21
====================================
A session had already been started - ignoring session_start() at D:\website\data\web\kimgo_source\functions\dhtmlxConnector1.5\xss_filter.php line 178
SELECT DISTINCT `status` as value FROM `vw_school_objuser` WHERE ( `objid` = '56')
SELECT DISTINCT `speciality` as value FROM `vw_school_objuser` WHERE ( `objid` = '56')
SELECT DISTINCT `mbrtype` as value FROM `vw_school_objuser` WHERE ( `objid` = '56')
SELECT '' `cntr` ,CONCAT( `tag` , '_' , `mbrno` ) `id` , `tag` , `mbrno` , `mbrtype` , `objid` , `uid` , `startyear` , `endyear` , `status` , `speciality` , `objname` , `realname` FROM `vw_school_objuser` WHERE ( `objid` = '56') ORDER BY `mbrno` ASC LIMIT 0,30
SELECT COUNT(*) as DHX_COUNT FROM `vw_school_objuser` WHERE ( `objid` = '56')
Done in 0.087008953094482s
====================================
Log started, 19/04/2014 09:04:23
====================================
A session had already been started - ignoring session_start() at D:\website\data\web\kimgo_source\functions\dhtmlxConnector1.5\xss_filter.php line 178
SELECT DISTINCT `status` as value FROM `vw_school_objuser` WHERE ( `objid` = '114')
SELECT DISTINCT `speciality` as value FROM `vw_school_objuser` WHERE ( `objid` = '114')
SELECT DISTINCT `mbrtype` as value FROM `vw_school_objuser` WHERE ( `objid` = '114')
SELECT '' `cntr` ,CONCAT( `tag` , '_' , `mbrno` ) `id` , `tag` , `mbrno` , `mbrtype` , `objid` , `uid` , `startyear` , `endyear` , `status` , `speciality` , `objname` , `realname` FROM `vw_school_objuser` WHERE ( `objid` = '114') ORDER BY `mbrno` ASC LIMIT 0,30
SELECT COUNT(*) as DHX_COUNT FROM `vw_school_objuser` WHERE ( `objid` = '114')
Done in 0.20938682556152s
====================================
Log started, 19/04/2014 09:04:33
====================================
A session had already been started - ignoring session_start() at D:\website\data\web\kimgo_source\functions\dhtmlxConnector1.5\xss_filter.php line 178
SELECT DISTINCT `status` as value FROM `vw_school_objuser` WHERE ( `objid` = '112')
SELECT DISTINCT `speciality` as value FROM `vw_school_objuser` WHERE ( `objid` = '112')
SELECT DISTINCT `mbrtype` as value FROM `vw_school_objuser` WHERE ( `objid` = '112')
SELECT '' `cntr` ,CONCAT( `tag` , '_' , `mbrno` ) `id` , `tag` , `mbrno` , `mbrtype` , `objid` , `uid` , `startyear` , `endyear` , `status` , `speciality` , `objname` , `realname` FROM `vw_school_objuser` WHERE ( `objid` = '112') ORDER BY `mbrno` ASC LIMIT 0,30
SELECT COUNT(*) as DHX_COUNT FROM `vw_school_objuser` WHERE ( `objid` = '112')
Done in 0.17020106315613s
====================================
Log started, 19/04/2014 09:04:45
====================================
A session had already been started - ignoring session_start() at D:\website\data\web\kimgo_source\functions\dhtmlxConnector1.5\xss_filter.php line 178
SELECT DISTINCT `status` as value FROM temp
SELECT DISTINCT `speciality` as value FROM temp
SELECT DISTINCT `mbrtype` as value FROM temp
SELECT `id`,`cntr`,`objname`,`mbrno`,`tag`,`realname`,`startyear`,`endyear`,`status`,`speciality`,`mbrtype` FROM temp LIMIT 0,30
SELECT COUNT(*) as DHX_COUNT FROM temp
Done in 0.069891929626465s