CODEWITHSUNDEEP
phpsqlcakephp
Roderick Domondon
Roderick Domondon

Reputation: 11

Cakephp about query is it possible?

I have a question about cakephp about there $this->query is it possible to combine three query and make it one,?example like this

$this->Training->query(Select sample.* from sample where sample.name like "me")
$this->Training->query(Select sample2.* from sample2 where sample2.name like "you")
$this->Training->query(Select sample3.* from sample3 where sample3.name like "us")

this is a search function combination,2 selectbox and 1 textbox

Upvotes: 0

Views: 132

Answers (1)

Rikesh
Rikesh

Reputation: 26421

Simply use UNION clause,

$this->Training->query(Select sample.* from sample where sample.name like "me"
                 UNION Select sample2.* from sample2 where sample2.name like "you"
                 UNION Select sample3.* from sample3 where sample3.name like "us")

Upvotes: 1

Related Questions