[eluser]attosolutinos[/eluser]
Ok here is the code that I am using. first the create table from mysql:
CREATE TABLE `member` (
`memberid` int(10) unsigned NOT NULL auto_increment,
`farmid` int(10) unsigned NOT NULL,
`prifirstname` varchar(60) NOT NULL,
`prilastname` varchar(60) NOT NULL,
`pristreet1` varchar(60) NOT NULL,
`pristreet2` varchar(60) NOT NULL,
`pricity` varchar(45) NOT NULL,
`pristate` varchar(10) NOT NULL,
`pridayphone` varchar(20) NOT NULL,
`prievephone` varchar(20) NOT NULL,
`priemail` varchar(60) NOT NULL,
`priemail2` varchar(60) NOT NULL,
`parfirstname` varchar(60) NOT NULL,
`parlastname` varchar(60) NOT NULL,
`parstreet1` varchar(60) NOT NULL,
`parstreet2` varchar(60) NOT NULL,
`parcity` varchar(60) NOT NULL,
`parstate` varchar(60) NOT NULL,
`parzip` varchar(10) NOT NULL,
`prizip` varchar(10) NOT NULL,
`pardayphone` varchar(20) NOT NULL,
`parevephone` varchar(20) NOT NULL,
`paremail` varchar(60) NOT NULL,
`pickupid` int(10) unsigned NOT NULL,
`pickupcounty` varchar(45) NOT NULL,
`homedelivery` bit(1) NOT NULL,
`locationhost` bit(1) NOT NULL,
`fielddays` bit(1) NOT NULL,
`willhelp` bit(1) NOT NULL,
`comments` text NOT NULL,
`farmernotes` text NOT NULL,
`referredby` varchar(200) NOT NULL,
`signup` date NOT NULL,
`paymentplan` int(10) unsigned NOT NULL,
`farmernumber` varchar(45) NOT NULL,
PRIMARY KEY (`memberid`),
KEY `farmid` (`farmid`),
KEY `pickupid` (`pickupid`)
) ENGINE=MyISAM AUTO_INCREMENT=3631 DEFAULT CHARSET=latin1 COMMENT='Member table'
Now that you have that here is the query that I use to go and get the record. This function is in a model.
function MemberReview($farmid,$Sort){
$this->db->select("concat(prifirstname, ' ',prilastname) as `Name`,
prizip as `Zip`,pridayphone as `DayPhone`,
prievephone as `EvePhone`,
priemail as `Email`,memberid",FALSE);
if ($Sort == "" || $Sort == "name"){
$this->db->order_by('prilastname');
} elseif ($Sort == "zip"){
$this->db->order_by('prizip');
} else {
$this->db->order_by('priemail');
}
$query = $this->db->get_where("csa.member",array('farmid'=>$farmid),'',False);
return $query;
}
Here is my function from the controller:
function members($Sort=""){
// this will go through and gather all the members and show them
$this->load->model('farmermodel');
//$this->load->library('form');
$this->load->library('table');
$MemberTable = $this->farmermodel->MemberReview($this->session->userdata("farmid"),$Sort);
// wee need to build an array then pass the array to the view
//print_r($MemberTable);
$tabledata=array();
foreach ($MemberTable->result() as $row){
$memberlink = "<a >memberid ."\">" . $row->Name . "</a>";
$emaillink = "<a >Email . "\">" . $row->Email . "</>";
$temp = array("Name"=>$memberlink,
"Zip" =>$row->Zip,
"DPhone"=>$row->DayPhone,
"EPhone"=>$row->EvePhone,
"Email"=>$emaillink);
$tabledata[$row->memberid] = $temp;
}
$data=array('Memebers'=>$tabledata);
$this->load->view('farmer/head.php');
$this->load->view('farmer/topBanner');
$this->load->view('farmer/menu');
$this->load->view('farmer/farmMember',$data);
$this->load->view('farmer/bottomBanner');
$this->load->view('farmer/footer');
}
No in the farmMember view I am accessing the data using the $farmernotes. When I print out the results array that field is empty. Does that help?
