what i did to be able to render the data in the UI as a selection is by this,
*Model
public function fetchCityName()
{
$connection = Yii::app()->db->createCommand("SELECT CityName from gg_t_worldareascities ORDER BY CityName ASC")->queryColumn();
return $connection;
}
<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
// change the following paths if necessary
$yii=dirname(__FILE__).'/yii/framework/yii.php';
$config=dirname(__FILE__).'/protected/config/main.php';
// remove the following lines when in production mode
defined('YII_DEBUG') or define('YII_DEBUG',true);
// specify how many levels of call stack should be shown in each log message
defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3);
require_once($yii);
Yii::createWebApplication($config)->run();
it doesn’t work…, when I click the create company link
In your situation I would enable different CFileLogRoute’s and log them in different log files to see what’s going on.
e.g for example:
One route that log the standard level logs like error, [b]warning
[/b]One route that logs only my own categories. This log messages are written before the possible problem (beginning in the controller/view where the "create company link" is displayed) zone in your code and after so you could see how far your code is correctly executed.
this problem was solved, i have a separate thread about the drop down menu, and solution was posted at yii wiki creating dependend dropdown, thanks for the help