====== cacheGetOne =====
<WRAP info>This function is deprecated in V6 and will be removed in a later release. Use [[v6:reference:connection:getOne()]] with caching parameters instead</WRAP> 
~~NOTOC~~

<WRAP right box>
== See Also ==
[[v6:reference:adodb_getone_eof|$ADODB_GETONE_EOF]]\\
== Syntax ==
    mixed cacheGetOne(
       mixed $cacheSeconds,
       optional string $sql=false
       optional array $bindvars=false
       )

</WRAP>
Cache functions search for the results of an executed query in the query cache. The results of a query have an expiration time specified by the first parameter. If an unexpired cache result is not found, the query is cached for the specified period.

For an explanation of the syntax of the other parameter of ''cacheGetOne()'', see [[v6:reference:connection:getassoc|getOne()]].
-----------------------------------
===== Usage =====
<code php>

$ADODB_GETONE_EOF = "-1";

$SQL = "SELECT MAX(tickets) FROM arena WHERE zip_code = '80111'";
$maxTickets = $db->cacheGetOne(100,$SQL);
</code>
{{tag>cache}}