is there any super easy cool trick to get the next id in codeigniter :))

is there any super easy cool trick to get the next id in codeigniter :))

El Forum
Guest

07-24-2009, 06:52 PM

[eluser]NateL[/eluser]
Since you have the ID in the URI, you will have to run this very simple query:

SELECT * FROM `clients` WHERE `clientid` > *segment 3* LIMIT 1;

That query will grab the next highest ID, even if you are missing ID's between. The LIMIT 1 is very important in this.

Messages In This Thread

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-24-2009, 06:06 PM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-24-2009, 06:15 PM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-24-2009, 06:23 PM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-24-2009, 06:27 PM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-24-2009, 06:28 PM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-24-2009, 06:32 PM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-24-2009, 06:52 PM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-25-2009, 10:57 AM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-26-2009, 01:32 AM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-26-2009, 07:59 AM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-26-2009, 10:07 AM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-26-2009, 10:18 AM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-26-2009, 11:17 AM

is there any super easy cool trick to get the next id in codeigniter :)) - by El Forum - 07-26-2009, 12:26 PM