Look up using the mysqli libraries. This was about a 30 second php.net
search.
http://us3.php.net/manual/en/mysqli.insert-id.php
Cheers,
Curtis
On 6/26/2013 1:33 PM, Tedd Sperling wrote:
Hi gang:
What's the most-current way to get the ID of the last recorded inserted in a
database?
Chee
On Jun 26, 2013, at 3:23 PM, Matijn Woudt wrote:
>
> What storage engine are you using? InnoDB is known for it's auto increment
> holes, but I didn't expect the holes to be that big.
I have no idea.
It's not my database. It's Constant Contact's -- I just put stuff in it as per
client's needs
On Jun 26, 2013, at 2:10 PM, Dan Munro wrote:
> Learning something new everyday is one of the joys of this profession. If you
> learn two new things, consider yourself lucky :)
What if it's the same two things?
"New" just means I didn't remember it.
Cheers,
tedd
_
ted
On 06/26/2013 10:07 AM, Tedd Sperling wrote:
Hi gang:
I have a client where their next auto-increment number just jumped from 2300 to
10 for reasons not understood. They want it set back.
Options such as dropping the primary key and rebuilding the index is NOT
possible -- this is a re
On Wed, Jun 26, 2013 at 7:35 PM, Tedd Sperling wrote:
> On Jun 26, 2013, at 1:32 PM, Jim Giner
> wrote:
>
> >> But more importantly - don't you need to figure out why it happened??
> As well as correcting any inserts with the bogus id?
>
>
> Yes, I would like to know -- I'm open for suggestions.
On 06/26/2013 08:03 PM, Samuel Lopes Grigolato wrote:
> AFAIK "mysql_[...]" is deprecated in favor of "mysqli_[...]" correspondent
> functions, there's nothing to do specifically with mysql[i]_insert_id.
>
>
> On Wed, Jun 26, 2013 at 3:01 PM, Tedd Sperling wrote:
>
>> On Jun 26, 2013, at 1:56 PM
Learning something new everyday is one of the joys of this profession. If
you learn two new things, consider yourself lucky :)
On Wed, Jun 26, 2013 at 11:03 AM, Samuel Lopes Grigolato <
samuel.grigol...@gmail.com> wrote:
> AFAIK "mysql_[...]" is deprecated in favor of "mysqli_[...]" corresponden
AFAIK "mysql_[...]" is deprecated in favor of "mysqli_[...]" correspondent
functions, there's nothing to do specifically with mysql[i]_insert_id.
On Wed, Jun 26, 2013 at 3:01 PM, Tedd Sperling wrote:
> On Jun 26, 2013, at 1:56 PM, Stuart Dallas wrote:
> > On Wednesday, 26 June 2013 at 18:39, Te
On Wednesday, 26 June 2013 at 19:01, Tedd Sperling wrote:
> On Jun 26, 2013, at 1:56 PM, Stuart Dallas (mailto:stu...@3ft9.com)> wrote:
> > On Wednesday, 26 June 2013 at 18:39, Tedd Sperling wrote:
> > > Let me add, currently I am inserting an email address into a database.
> > >
> > > To find wh
On Jun 26, 2013, at 1:56 PM, Stuart Dallas wrote:
> On Wednesday, 26 June 2013 at 18:39, Tedd Sperling wrote:
>> Let me add, currently I am inserting an email address into a database.
>>
>> To find which record was created, I ask for the record number (ID) back.
>>
>> I am asking simply because
On Wednesday, 26 June 2013 at 18:39, Tedd Sperling wrote:
> Let me add, currently I am inserting an email address into a database.
>
> To find which record was created, I ask for the record number (ID) back.
>
> I am asking simply because mysql_insert_id() is deprecated.
>
How are you doing th
Gang:
Let me add, currently I am inserting an email address into a database.
To find which record was created, I ask for the record number (ID) back.
I am asking simply because mysql_insert_id() is deprecated.
Cheers,
tedd
_
tedd.sperl...@gmail.com
http://sperling.com
--
On Jun 26, 2013, at 1:32 PM, Jim Giner wrote:
>> But more importantly - don't you need to figure out why it happened?? As
>> well as correcting any inserts with the bogus id?
Yes, I would like to know -- I'm open for suggestions.
Cheers,
tedd
_
tedd.sperl...@gmail.com
ht
Hi gang:
What's the most-current way to get the ID of the last recorded inserted in a
database?
Cheers,
tedd
_
t...@sperling.com
http://sperling.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 6/26/2013 1:30 PM, Tedd Sperling wrote:
On Jun 26, 2013, at 1:13 PM, Stuart Dallas wrote:
On Wednesday, 26 June 2013 at 18:07, Tedd Sperling wrote:
Hi gang:
I have a client where their next auto-increment number just jumped from 2300 to
10 for reasons not understood. They want it
On Jun 26, 2013, at 1:13 PM, Stuart Dallas wrote:
> On Wednesday, 26 June 2013 at 18:07, Tedd Sperling wrote:
>> Hi gang:
>>
>> I have a client where their next auto-increment number just jumped from 2300
>> to 10 for reasons not understood. They want it set back.
>>
>> Options such as
On Wednesday, 26 June 2013 at 18:07, Tedd Sperling wrote:
> Hi gang:
>
> I have a client where their next auto-increment number just jumped from 2300
> to 10 for reasons not understood. They want it set back.
>
> Options such as dropping the primary key and rebuilding the index is NOT
>
You can try this: *ALTER TABLE tbl AUTO_INCREMENT = 100;*
*
*
*Source: *http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
(never did it myself, though)
On Wed, Jun 26, 2013 at 2:07 PM, Tedd Sperling wrote:
> Hi gang:
>
> I have a client where their next auto-increment number j
Hi gang:
I have a client where their next auto-increment number just jumped from 2300 to
10 for reasons not understood. They want it set back.
Options such as dropping the primary key and rebuilding the index is NOT
possible -- this is a relational table thing.
So, is there a way (prog
19 matches
Mail list logo
