°ïÎÒ¿´¿´ÏÂÃæÁ¬½ÓOracleÊý¾Ý¿âµÄ´úÂëÄĶù´íÁË£¿

require_once ("smarty/libs/Smarty.class.php");
require_once("adodb/adodb.inc.php");

  $staID = "54511";
    $days = 0;
    $dsn = 'oci8://****:*******@192.168.39.113:1521/portaldb?charset=UTF8';
    $db = ADONewConnection($dsn);
    //
    for($i = 0; $i < 100 ; $i++)
    {
    $sql = "select * from observe.ele_surf
                    where v01000  = '$staID'
                    and c_bjtime like to_char((sysdate-'$i'),'yyyymmdd')||'080000'
                    and V13023 = 0";              
    $rs = $db -> Execute($sql); 
    $Rcount = $rs->RecordCount();      
    if($Rcount == 1)
{
$days = $days + 1;
echo "0";            
}
else
{
    echo "1";
}
}


$rs = $db -> Execute($sql);  Õâ¿é³ö´íÁË£ºcall a member function  Execute() on a non object.

---

Êý¾Ý¿âÔ´Á¬½Ó