Mega Code Archive

 

Categories / Php / MySQL Database

 

Using the sqlite_seek() Function

<?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)); ?>