<?php include('adodb.inc.php'); # load code common to ADOdb $ADODB_CACHE_DIR='/usr/ADODB_cache'; $conn=&ADONewConnection('mysql'); # create a connection $conn->PConnect('localhost','userid','','agora');# connect to MySQL, agora db $sql='select CustomerName, CustomerID from customers'; $rs=$conn->CacheExecute(15,$sql); ?>