Help with query

[owner]

Could someone help me convert this over to the IP.Board style

 

SELECT * FROM `test` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `test` ) ORDER BY id LIMIT 1

 

to

	$this->DB->build( array( 'select'   => '*',
							'from'		=> 'test',
							'where'		=> 'id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `test` )',
							'limit'		=> array( 0, 5 )
							)	   );

 

The bottom code doesn't work, but I need to convert the query above to work with the bottom one.

 

Thanks in advance!

-owner

[Michael]

Don't think it's possible to have a select query inside where. What about this instead?

 

$this->DB->query("SELECT * FROM `test` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `test` ) ORDER BY id LIMIT 1");