jmoncayo

foreach(PmsDB::getFolderMessages(Session::singleton()->get("user_ID"),$box) AS $message){
                                        echo '<tr><td width="10"><input type="checkbox" name="checkbox[]" value="'.$message['pm_ID'].'" /></td>';
                                        $class = $message['pm_READ_STATUS'] == FALSE ? 'unread' : 'read';
                                        echo '<td class="'.$class.'"></td><td>'.$message['pm_GET'].'</td>';
                                        echo '<td>'.$message['pm_TITLE'].'</td>';
                                        echo '<td width="120">'.$message['pm_DATE'].'</td></tr>';
                                }
        public function getFolderMessages($id, $folder){
                $sql = "SELECT user_NAME AS pm_GET,pm_ID,pm_DATE,pm_TITLE,pm_READ_STATUS FROM pms,users".
                       " WHERE pm_RECEIVER=user_ID AND pm_FOLDER='$folder' AND pm_OWNER='$id' ORDER BY pm_DATE DESC";
                $result = MysqlDB::singleton()->getAll("SELECT * FROM pms WHERE pm_FOLDER='$folder' AND pm_OWNER='$id'");
                return $result == FALSE ? FALSE : $result;
        }



Notice: Undefined index: pm_GET in /htdocs/pms.php on line 43

i am using mysql_fetch_assoc


SELECT user_NAME AS pm_GET,pm_ID,pm_DATE,pm_TITLE,pm_READ_STATUS 
FROM pms,users  
WHERE pm_RECEIVER=user_ID AND pm_FOLDER='$folder' AND pm_OWNER='$id' ORDER BY pm_DATE DESC;

CREATE TABLE users (
user_ID int(10) unsigned auto_increment primary key,
user_NAME varchar(20) not null,
)
ENGINE="MyISAM";

CREATE TABLE pms (
pm_ID int(10) unsigned auto_increment primary key,
pm_TITLE varchar(50) not null default 'no_title',
pm_MESSAGE text not null ,
pm_DATE datetime not null default '0000-00-00 00:00:00',
pm_READ_STATUS boolean not null default false,
pm_FOLDER int(10) unsigned,
pm_OWNER int(10) unsigned, /* USER ID */
pm_RECEIVER int(10)  unsigned /* USER ID */
)
ENGINE="MyISAM";