Elxis CMS Forum
Support => Elxis 2008 developers guide => Topic started by: datahell on October 05, 2007, 22:45:30
-
If you wish to order randomly the results from the database then dont use "ORDER BY RAND()" as it is a native mysql function and only works on Elxis under MySQL. In this case you should use the $random variable of ADODB which is set automatically for every database type.
Instead of this:
$query = "SELECT........."
."\n ORDER BY RAND()";
Use this:
$randfunc = $database->_resource->random;
$query = "SELECT........."
."\n ORDER BY ".$randfunc;
The randomize function for MySQL is RAND() and for Postgres is RANDOM()