Re: RE: non-auto increment question

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,��� > >>> ��x���`�C�y"content) > >>> VALUES('$title','$content')"; > >>> $result = mysql_query($query); > >>> $autoId = mysql_insert_id($result); > >>> > >>> $query = "INSERT INTO another_table({ > >>> �_P7�ȂB9link_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@ptahhotep.com > http://www.ptahhotep.com > http://www.chiccantine.com > > Only in America! Ash www.ashleysheridan.co.uk