7my356nT

1CREATE TABLE IF NOT EXISTS `categories` (
2  `idCategory` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `name` varchar(64) NOT NULL,
4  PRIMARY KEY (`idCategory`) USING BTREE
5) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;
6	
7$names = array();
8    public function returnCategoryNames()
9{
10    $dataProvider= new CActiveDataProvider('Categories');
11    $dataProvider->setPagination(false);
12    $count = $dataProvider->totalItemCount();
13
14    for($i = 0; $i < $count; $i++){
15
16             // this is where I am lost...
17             $myname = $dataProvider->data[$i]->name;
18             array_push($names, $myname);
19
20    }   
21
22       return $names;
23
24}
25	
26public function returnCategoryNames()
27{
28  $dataProvider= new CActiveDataProvider('Categories');
29  $dataProvider->setPagination(false);
30  //$count = $dataProvider->totalItemCount();
31  $names = array();
32  foreach($dataProvider->getData() as $record) {
33    $names[] = $record->name;
34  }
35  return array_unique($names);
36}
37	
38foreach(Categories::model()->findAll() as $record) {