What does this show you in the view? debug($projects);
On Thu, Mar 19, 2009 at 8:59 AM, cpeele <[email protected]> wrote: > > Hello, thanks for replying. > > Sorry about that. > > What I want is to grab all the projects that pertain to a certain > user...by username. > > Here is what the DB tables look like: > > users > -------------- > id > firstName > lastName > username > password > > projects > ----------------- > id > name > description > user_id > > Here is how the models look: > > User > ------------------ > class User extends AppModel > { > var $name = 'User'; > var $hasMany = array('Event', 'Project'); > } > > > Project > -------------------- > > class Project extends AppModel > { > var $name = 'Project'; > var $belongsTo = 'User'; > } > > Thanks again! > > On Mar 18, 9:38 pm, nhathoang nhathoang <[email protected]> > wrote: >> Dear cpeele, >> I see your question is not clearly , what do you want when you use this >> query $projects = $this->Project->User->findByUsername($username);, and >> please post your database on forum >> >> 2009/3/19 cpeele <[email protected]> >> >> >> >> > Hey guys, I am getting an Undefined index error. I am rather new to >> > cakePHP so it is probably something easy I am missing. >> > I will post the code with descriptions. >> >> > I have an element called "project_updates": >> > <table> >> > <?php foreach($projects as $project): ?> >> > <?php $dateTime = date_create($project['Project']['created']); ?> >> > <tr> >> > <td> >> > <!-- ************ This link passes the "username" into >> > the ProjectController's view method taking the username as an argument >> > *******************--> >> > <?php echo $html->link($project['Project']['name'], >> > "/projects/ >> > view/".$project['User']['username']); ?><br /> >> >> > <span style="font-size:12px"><?php echo >> > $project['User'] >> > ['username'] . " - " . date_format($dateTime, 'd/M/y'); ?></span> >> > </td> >> > </tr> >> > <tr> >> > <td style="padding-top: 10px;"> >> > <?php echo $project['Project']['description']; ?> >> > </td> >> > </tr> >> > <tr> >> > <td><br /></td> >> > </tr> >> > <?php endforeach ?> >> > </table> >> >> > here is the ProjectsController action code: >> >> > function view($username) >> > { >> > $projects = $this->Project->User->findByUsername($username); >> > $this->set('projects', $projects); >> > } >> >> > Project has a foreign key reference to User. I want to grab all the >> > projects by a particular username that is being passed in by the above >> > element. >> >> > Here is the view.ctp code >> >> > <?php foreach($projects as $project): ?> >> > <?php echo $project['Project']['name']; ?> >> > <?php endforeach ?> >> >> > When it tries to echo the project name it throws the undefined index >> > error. >> >> > Any help would be greatly appreciated! >> >> > Thanks, >> >> > Chris > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
