Pham Huu Le Quoc Phuc a écrit :
I catch an error, could you tell me if you have some ideas?

class Dsptraining extends AppModel
{
     function GetDsptrainings()
     {
          return $this->findBySql("select max(start_date) start_date from
tbl_dsptrainings");
     }
}

did you try your sql query directly using sql ?
try this one :

select max(start_date) as start_date from tbl_dsptrainings

N F
class DsptrainingsController extends AppController
{
        function index()
        {
          $data = $this->Dsptraining->GetDsptrainings();
          echo $data[0]['start_date'];
      }
}

Error message: Undefined index: start_date in
c:\Inetpub\wwwroot\Cake\app\controllers\dsptrainings_controller.php on line
33


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to