How to save the query result in a variable and use it in another query

Question

I want to save the last generated voucher in a variable and used as an input for another query..

$last = $this->db->query('SELECT MAX(voucherno) AS `last` FROM `purchasebill` ORDER BY no DESC LIMIT 1')->row_array();
    $result = $this->db->query("SELECT * FROM `purchaseitem`  where vno= '$last[0]' ORDER BY  vno " )->result_array();

I tried like the above code it gives me an error undefined offset 0..Help me to save the last generated voucher no in an last variable

Samir Selia · Accepted Answer · 2018-11-27 08:18:47Z

1

As per the document, $last[0] will return entire first row. In your case you want to access the value of MAX(voucherno) which is stored in an alias last.

Change $last[0] to $last['last'] in your next query and it shall work.

"SELECT * FROM `purchaseitem` WHERE vno = '{$last['last']}' ORDER BY vno"

answered Nov 27, 2018 at 8:18

Samir Selia

7,1502 gold badges14 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

How to save the query result in a variable and use it in another query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related