MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:February 26 2009 9:00pm
Subject:RE: [PHP] RE: non-auto increment question
View as plain text  
Sorry, I should know better.

>-----Original Message-----
>From: Ashley Sheridan [mailto:ash@stripped]
>Sent: Thursday, February 26, 2009 1:51 PM
>To: Jerry Schwartz
>Cc: 'PJ'; 'Gary W. Smith'; 'MySql'; php-general@stripped
>Subject: RE: [PHP] RE: non-auto increment question
>
>On Thu, 2009-02-26 at 13:44 -0500, Jerry Schwartz wrote:
>> >Here's how I mostly do it (albeit simplified):
>> >
>> >$query = "INSERT INTO `sometable`(`title`,`content`)
>> >VALUES('$title','$content')";
>> >$result = mysql_query($query);
>> >$autoId = mysql_insert_id($result);
>> >
>> >$query = "INSERT INTO `another_table`(`link_id`,`value`)
>> >VALUES($autoId,'$value');
>> >$result = mysql_query($query);
>> >
>> >No need to call another query to retrieve the last inserted id, as it
>is
>> >tied to the last query executed within this session.
>> >
>> >
>> >Ash
>> >www.ashleysheridan.co.uk
>>
>> [JS] Ashley is absolutely right, I'd forgotten about the
>mysql_insert_id
>> shorthand. (I'm a one-man band, and for the last week or two I've been
>> immersed in VB for Access forms.) Not only is she right, but her way
>is
>> better. Presumably a language's internal code is maintained as the
>specific
>> database changes. You can make yourself more independent of the
>specific
>> database by using the PDO abstraction, although I would save that for
>a
>> rainy weekend.
>>
>> Regards,
>>
>> Jerry Schwartz
>> The Infoshop by Global Information Incorporated
>> 195 Farmington Ave.
>> Farmington, CT 06032
>>
>> 860.674.8796 / FAX: 860.674.8341
>>
>> www.the-infoshop.com
>> www.giiexpress.com
>> www.etudes-marche.com
>>
>>
>>
>>
>>
>>
>>
>I just checked, and yep, I'm definitely still a he ;)
>
>
>Ash
>www.ashleysheridan.co.uk




Thread
Re: [PHP] RE: non-auto increment questionPJ26 Feb
  • RE: [PHP] RE: non-auto increment questionJerry Schwartz26 Feb
  • RE: [PHP] RE: non-auto increment questionJerry Schwartz26 Feb
    • Re: [PHP] RE: non-auto increment questionPJ26 Feb
      • RE: [PHP] RE: non-auto increment questionJerry Schwartz26 Feb
  • RE: [PHP] RE: non-auto increment questionGary W. Smith27 Feb
RE: [PHP] RE: non-auto increment questionJerry Schwartz26 Feb
Re: [PHP] RE: non-auto increment questionPJ26 Feb
RE: [PHP] RE: non-auto increment questionJerry Schwartz26 Feb
Re: [PHP] RE: non-auto increment questionPJ11 Mar