Problem on view from custom sql

Dear All
   
  i have problem for show on view    because  custom sql 

this  custome sql 

    $querys = "select * from registers where id is not null and (phone like '%$q%' ";
                $querys .= " or endyear like '%$q%' ";
                $querys .= " or address like '%$q%'";
                $querys .= " or name like  '%$q%' ";
                $querys .= " or studentCode like '%$q%' ) ";
                $searchs = $this -> Register -> query($querys);
                 
                $this -> set(compact('searchs'));

and view   have error   :

Undefined index: studentCode

    <?php foreach ($searchs as $register):
        ?>
        <tr>
        <td><?= $register['studentCode']; ?></td>
 
        </tr>
        <?php endforeach; ?>

plz guide me 

thank you

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.