Attempt to implement SQL using CodeIgniter's active record emits error: Missing argument 2 for CI_DB_active_record::join() [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 7 months ago.

Improve this question

I am try to join with two table.
This is my simple sql query:

$sql = "SELECT windows_users_image_upload.*, `windows_users_info`.`display`
        FROM `windows_users_image_upload`,`windows_users_info`
        WHERE `windows_users_info`.`user_id` = `windows_users_image_upload`.`user_id`
            AND " . $field . "=" . $value;

It works fine, but I want to use CodeIgniter's query builder methods; something like this:

$this->db->select("windows_users_image_upload.*,windows_users_info.display");
$this->db->from("windows_users_info,windows_users_image_upload");
$this->db->where("windows_users_image_upload.".$field,$value);
$this->db->limit($takeTuple, $startTuple);
$this->db->join("windows_users_image_upload,windows_users_image_upload.user_id = windows_users_info.user_id");
$result = $this->db->get()->result();

but it's showing me this error:

Message: Missing argument 2 for CI_DB_active_record::join()

How can I fix this?

try $this->db->join("windows_users_image_upload","windows_users_image_upload.user_id = windows_users_info.user_id"); — Pranav C Balan
– Pranav C Balan, Commented Nov 30, 2013 at 11:05
You haven't shown the definition of your table(s), without which it's hard to give a good answer. See Why should I provide an MCVE for what seems to me to be a very simple SQL query? — Toby Speight
– Toby Speight, Commented Apr 26 at 13:06

Hugo B. · Accepted Answer · 2013-11-30 11:00:23Z

1

This is how you use a join in CodeIgniter:

$this->db->select('*');
$this->db->from('blogs');
$this->db->join('comments', 'comments.id = blogs.id');

$query = $this->db->get();

// Produces:
// SELECT * FROM blogs
// JOIN comments ON comments.id = blogs.id1

You can see it in the User-Guide of CodeIgniter.

http://ellislab.com/codeigniter/user-guide/database/active_record.html#select

answered Nov 30, 2013 at 11:00

Hugo B.

5031 gold badge10 silver badges26 bronze badges

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

Comments

Elcio Arthur Cardoso · Accepted Answer · 2013-11-30 11:31:07Z

1

You have to remove de second table in from command:

Example:

 $this->db->select('windows_users_image_upload.*,windows_users_info.display');
 $this->db->from('windows_users_info');
 $this->db->join("windows_users_image_upload","windows_users_image_upload.user_id = windows_users_info.user_id");
 $this->db->where("windows_users_image_upload.".$field,$value);

 $query = $this->db->get();

edited Nov 30, 2013 at 11:31

answered Nov 30, 2013 at 11:02

Elcio Arthur Cardoso

471 silver badge8 bronze badges

1 Comment

웃웃웃웃웃 Over a year ago

$this->db->select("windows_users_image_upload.*,windows_users_info.display"); $this->db->from("windows_users_info"); $this->db->where("windows_users_image_upload.".$field,$value); $this->db->limit($takeTuple, $startTuple); $this->db->join("windows_users_image_upload","windows_users_image_upload.user_id = windows_users_info.user_id"); $result = $this->db->get()->result();

Collectives™ on Stack Overflow

Attempt to implement SQL using CodeIgniter's active record emits error: Missing argument 2 for CI_DB_active_record::join() [closed]

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related