Re: RE: non-auto increment question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2009-02-26 at 14:04 -0500, PJ wrote:
> Ashley Sheridan wrote:
> > 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 ;)
> >
> >   
> I never thought otherwise... but then I was wondering... there are too
> many actresses with the same name... ;-)
> 
> -- 
> 
> Phil Jourdan --- pj@xxxxxxxxxxxxx
>    http://www.ptahhotep.com
>    http://www.chiccantine.com
> 
> 
Only in America!


Ash
www.ashleysheridan.co.uk


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux