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