Mega Code Archive

 

Categories / Php / MySQL Database

 

Sqlite_seek php

<?php    $sqldb = sqlite_open("mydatabase.db");    $results = sqlite_query($sqldb, "SELECT empid, name FROM employee");    $random = rand(0,sqlite_num_rows($results)-1);    sqlite_seek($results, $random);    list($empid, $name) = sqlite_current($results);    echo "Randomly chosen employee of the month: $name (Employee ID: $empid)";    sqlite_close($sqldb); ?>