='".$_SESSION['site810_inDatefrom']."' and ORD_AUDIT_DATE<='".$_SESSION['site810_inDateto']."'"; $query .=" order by ORD_AUDIT_DATE desc"; if (empty($_SESSION['site810_sr_all'])) $query .=" limit 100"; $res=null; $wynik = mysql_query($query); if($wynik)while ($r = mysql_fetch_array($wynik)) { $res[]=array( 'orderID' => $r["ORD_ID"], 'orderNo' => $r["ORD_NO"], 'devID' => $r["ORD_DRS_ID"], 'devName' => $r["ORD_OBJ_NAME"], 'devType' => $r["ORD_OBJ_TYPE"], 'bariera' => $r["SOD_UJ"], 'plc' => $r["SOD_PLC"], 'orderScopeID'=> $r["ORD_SCOPE_DIC_ID"], 'orderScope' => setDicName($r["ORD_SCOPE_DIC_ID"]), 'orderStatus' => setDicName($r["ORD_STATUS_DIC_ID"]), 'orderDate' => substr($r["ORD_AUDIT_DATE"],0,10) ); } unset($_SESSION['site810_array']); $_SESSION['site810_array']=$res; } // sortowanie wyników // =========================================================================================== // if ($_GET['f0']=='a') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderNo', 'ASC','str'); else if ($_GET['f0']=='z') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderNo', 'DESC','str'); else if ($_GET['f1']=='a') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'devName', 'ASC','str'); else if ($_GET['f1']=='z') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'devName', 'DESC','str'); else if ($_GET['f2']=='a') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'bariera', 'ASC','str'); else if ($_GET['f2']=='z') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'bariera', 'DESC','str'); else if ($_GET['f3']=='a') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderScope', 'ASC','str'); else if ($_GET['f3']=='z') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderScope', 'DESC','str'); else if ($_GET['f4']=='a') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderDate', 'ASC','str'); else if ($_GET['f4']=='z') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderDate', 'DESC','str'); else if ($_GET['f5']=='a') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderStatus', 'ASC','str'); else if ($_GET['f5']=='z') $_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderStatus', 'DESC','str'); // =========================================================================================== // $start=($_GET['pgn']-1)*20; $stop = $_GET['pgn']*20; if ($stop>count($_SESSION['site810_array'])) $stop=count($_SESSION['site810_array']); for($i=$start;$i<$stop;$i++) { $bgcol=null; if ($_SESSION['site810_array'][$i]['orderStatus']=='Zakończone') $bgcol = "background-color: rgba(0, 255, 0, 0.1);"; echo" "; } ?>

Lp.
".($i+1).".	".$_SESSION['site810_array'][$i]['orderNo']."	".$_SESSION['site810_array'][$i]['devName']."	".$_SESSION['site810_array'][$i]['bariera']."	".$_SESSION['site810_array'][$i]['orderScope']."	".$_SESSION['site810_array'][$i]['orderDate']."	".$_SESSION['site810_array'][$i]['orderStatus']."

Wyników:

20) echo pagination_grid('./?pg=site810', $_GET['pgn'], count($_SESSION['site810_array'])); ?>