Update and Return

Update and Return

02-20-2015, 04:49 AM

Shorter way:

Code:
$seq = $this->db->query("SELECT seq FROM table WHERE field='NEXTINV'")->row()->seq;

Make sure that field='NEXTINV' refers to a unique record. Best way is to refer to the ID column.

Messages In This Thread

Update and Return - by goodkarma - 02-19-2015, 11:57 AM

RE: Update and Return - by dbui - 02-19-2015, 09:12 PM

RE: Update and Return - by Wouter60 - 02-20-2015, 04:49 AM