<?php
function random_row($result) {
$t_rows = sqlite_num_rows($result);
if($t_rows > 0) {
sqlite_seek($result, rand(0, ($t_rows-1)));
return sqlite_current($result);
} else {
return false;
}
}
$sqlite = sqlite_open(":memory:");
sqlite_query($sqlite, "CREATE TABLE test(value INTEGER PRIMARY KEY)");
sqlite_unbuffered_query($sqlite, "INSERT INTO test VALUES(NULL)");
$result = sqlite_query($sqlite, "SELECT * FROM test");
var_dump(random_row($result));
?>
|