thanks Piotr Kilczuk let me chk with that..
On Fri, Jul 17, 2009 at 8:43 PM, Piotr Kilczuk <[email protected]> wrote:

>
> Hello,
>
> > Can i get a tutorial for making the a search functionality.
> > I have 3 types of users, each type have different table. I need to search
> > the users with first name , lastnmae , phone number, compnay. Can anybody
> > provide me the tutorial or structure.
> > Iam very new in cake php.
>
> You don't mention how you need the data organised, but...
>
> Are you sure that it's the best way to store these types? Why not
> store them in 1 table?
>
> Your case is an UNION query in SQL, so I think you'd have to use
> $model->query($yourCustomSQL) to get it right.
>
> You can find docs for $model->query() here:
> http://book.cakephp.org/view/456/query
>
> Regards,
> Piotr
>
> >
>


-- 
Thanks and Regards
Binoy
Sent from Bangalore, KA, India

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to