Mysql two column Find one data in Rows using PHP

Question

I have to try two joins but this is not going to work. code in Codeginator.

$this->db->select('concat(firstName," ",lastName) as fullnameVisitor,users.firstName,visitorId,destinationId,count,activityStatus,created,updated');
    $this->db->from('interestedprofile');
    $this->db->join('users','users.userId=interestedprofile.visitorId','LEFT');
    $this->db->join('users','users.userId=interestedprofile.destinationId','LEFT');
    $this->db->join('interestedprofile','interestedprofile.destinationId=users.userId','LEFT');
    $this->db->order_by('created','desc');
    return $this->db->get()->result_array();

User Table : https://i.sstatic.net/ppM3s.png Interest Table : https://i.sstatic.net/EbQIX.png

i have to find visitedid and destinationid users firstName and lastName in Users Table.

Dino Cajic · Accepted Answer · 2019-12-04 19:03:58Z

1

You don't have to use the Active Record fully to do the joins. You can use regular SQL. For example,

$query = $db->query("SELECT * FROM users;");

foreach ($query->getResult('User') as $user)
{
    echo $user->name; // access attributes
    echo $user->reverseName(); // or methods defined on the 'User' class
}

answered Dec 4, 2019 at 19:03

Dino Cajic

1381 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sandesh Mankar Over a year ago

codeselect us1.firstName,us2.firstName from interestedprofile ip join users us1 on us1.userid = ip.visitorId join users us2 on us2.userId = ip.destinationId code this query will be work. thanks

Sandesh Mankar · Accepted Answer · 2020-09-17 03:46:42Z

0

This Code is Work For me.

Select us1.firstName,us2.firstName from interestedprofile ip join users us1 on us1.userid = ip.visitorId join users us2 on us2.userId = ip.destinationId

answered Sep 17, 2020 at 3:46

Sandesh Mankar

6994 silver badges16 bronze badges

Collectives™ on Stack Overflow

Mysql two column Find one data in Rows using PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related