ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== cacheGetCol ======
~~NOTOC~~
<WRAP right box>
== syntax ==
   mixed cacheGetCol {
         mixed $cacheSeconds
         optional mixed $sql=ffalse
         optional string[] $bindvars=false
         optional bool $trimString=false
         }
</WRAP>

===== Description =====
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 ''cacheGetCol()'', see [[v5:reference:connection:getcol|getCol()]].
==== Usage ====
<code php>
/*
 * DB2 Connection assumed
*/
$ar = $db->cacheGetCol(2400,"SELECT * FROM ACT");

/*
 * $ar returns:
Array
(
    [0] => 10
    [1] => 20
    [2] => 30

.......
*/
            
</code>
{{tag>cache}}