06-20-2012, 03:34 PM
[eluser]RMinor[/eluser]
I am trying to get all of the information about a user from four different tables. The query I am using is below:
I am getting an empty result set even though I should be getting one row. Can anyone push me in the right direction to solving this?
I am trying to get all of the information about a user from four different tables. The query I am using is below:
Code:
$query = $this->db->query("SELECT * FROM user INNER JOIN user_resume ON user_id = user_resume_user INNER JOIN user_video ON user_id = user_video_user INNER JOIN user_pdf ON user_id = user_pdf_user WHERE user_id = ?", array($user_id));
I am getting an empty result set even though I should be getting one row. Can anyone push me in the right direction to solving this?