$connection = Yii::app()->db; $table = $connection->tablePrefix.'insurance'; $sql = "select insurance_id, insurance_urlname from $table where insurance_display='Y' and insurance_status='A'"; $command = $connection->createCommand($sql); $list = $command->execute();
ディスカッションに返信 ( solution)