select * from table order by order1,order2

SELECT * FROM products WHERE P_Up > 0 OR P_Up = 0

          $ogen_array = Array();
          $regul_array = Array();
          $oc = 0;
          $rc = 0;
        while ($prod = mysql_fetch_array($result)) {
                if ($prod{'P_Up'} > 0) {
                  
                    $ogen_array{$oc}{'P_Name'} = $pro{['P_Name'};
                    $ogen_array{$oc}{'P_Order'} = $prod{'P_Order'};
                    $ogen_array{$oc}{'P_Up'} = $prod{'P_Up'};
                    $oc ++;
                }
                else {
                $regul_array{$rc}{'P_Name'} = $pro{['P_Name'};
                    $regul_array{$rc}{'P_Order'} = $prod{'P_Order'};
                    $regul_array{$rc}{'P_Up'} = $prod{'P_Up'};
                    $rc ++;
                }
        }
    }