PHP Neevo BaseStatement::order Examples

Example #1

File: Neevo_Drivers_DummyDriver.php Project: smasty/neevo

 public function randomizeOrder(BaseStatement $statement)
 {
     $statement->order('RANDOM()');
 }

Example #2

File: pdo.php Project: smasty/neevo

 /**
  * Randomizes result order.
  * @param BaseStatement $statement
  */
 public function randomizeOrder(BaseStatement $statement)
 {
     switch ($this->driverName) {
         case 'mysql':
         case 'pgsql':
             $random = 'RAND()';
         case 'sqlite':
         case 'sqlite2':
             $random = 'RANDOM()';
         case 'odbc':
             $random = 'Rnd(id)';
         case 'oci':
             $random = 'dbms_random.value';
         case 'mssql':
             $random = 'NEWID()';
     }
     $statement->order($random);
 }