Fetching a random row from a sheet via php

[Alexandre Plennevaux]

Hi,

I built a php script that accesses my spreadsheet, gets all the rows as a 
list feed, then display one random row out of it. Works fine, but i'd like 
to optimize it.
Right now, i'm downloading the full data and then randomly chosing one 
element out of the php array.

Is there a way to build a query that makes the random selection happen 
inside the API?

Here is my current code in case it helps.


// Zend library include path
set_include_path(get_include_path() . PATH_SEPARATOR . 
$_SERVER[DOCUMENT_ROOT]."/ZendGdata/library");


// credits: http://farinspace.com/saving-form-data-to-google-spreadsheets/
include_once("Google_Spreadsheet.php");
 
$u = "gmaillogin";
$p = "gmailpassword";
 
$ss = new Google_Spreadsheet($u,$p);
$ss->useSpreadsheet("My Spreadsheet");
$ss->useWorksheet('My worksheet');
 
$rows = $ss->getRows();
if ($rows){
    $data  = returnRandomElement($rows);
    echo '<pre>';
    print_r($data);
} 
else {
   die("error");
}

// HELPERS

function returnRandomElement($array){
    return $array[array_rand($array,1)];
}