StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow do I pass multiple queried results to new a query
text
Body
copied!<p>I have succeeded in querying one table to get information that is needed to query another table (If you can see a better way I would be grateful!) </p> <p><strong>My question is:</strong> How can I have multiple values come back from the first query and have my second query come back with multiple results. As you can see I am inserting the returned result from query one into query two “msg_id = ?”(I use '$datas' to fill the ‘?’) but if my results from query one have multiple values then how will this work? </p> <p><strong>Also</strong> how can I make it get multiple results from query one? at the moment if there are multiple values in mysql it only grabs the first one it reads.</p> <p>My <strong>MODEL</strong> code is as follows:</p> <pre><code>function check() { $this->db->select('msgto_message'); $this->db->from('msgto'); $this->db->where('msgto_display', 'y'); $this->db->where('msgto_recipient', '1'); $w = $this->db->get(); if ($w->num_rows() > 0) { $rowe = $w->row_array(); $datas = $rowe['msgto_message']; } $sql = "SELECT msg_content FROM msg WHERE msg_id = ?"; $data = $this->db->query($sql, $datas) or die(mysql_error()); if ($data->num_rows() > 0) { foreach($data->result_array() as $row) { $data = $row; } return $data; } } </code></pre> <p>My <strong>CONTROLLER</strong> code is as follows:</p> <pre><code>function index() { $this->load->model('data_model'); $data['rows'] = $this->data_model->check(); $this->load->view('home', $data); } </code></pre> <p><strong>Thank you anyone that helps me, I greatly appreciate it!</strong></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload