Re: [chiPHPug-discuss] Last insert id using PEAR DB

[Hardik K. D. <do...@ii...>]

Hi Stan and Eric,

Thanks for your help. I understood the nextId() function of PEAR DB. 

Hardik

-----

Hardik K. Doshi
Web Application Developer

Institute of Design
Illinois Institute of Technology
350, North Lasalle Street
Chicago, Illinois 60610

312.595.4907 (direct)
312.595.4901 (fax)

----- Original Message -----
From: Stan Lemon <in...@my...>
Date: Wednesday, July 2, 2003 10:50 am
Subject: Re: [chiPHPug-discuss] Last insert id using PEAR DB

> Avoid using the query function, mainly because it defeats the 
> whole 
> point of using DB, it isn't a common function across SQL servers. 
> 
> There is s nextID() function in DB, he documentation is available 
> here:http://pear.php.net/manual/en/package.database.db.db-
> common.nextid.php
> Good luck,
> - Stan
> 
> Eric Bergen wrote:
> 
> >If all else fails you can always execute the query select 
> last_insert_id();>
> >Eric Bergen
> >Senior Webmaster
> >ItsYourDomain.com
> >1005 W. Wise Road
> >Schaumburg, IL  60193
> >(847) 895-4301 / Tel  -    (847) 895-4123 / Fax
> >http://www.itsyourdomain.com
> >fir...@it...
> >
> >"The Wholesale Registrar"
> >
> >On Wed, 2 Jul 2003, Hardik K. Doshi wrote:
> >
> >  
> >
> >>Hi Group,
> >>
> >>In mysql there are the functions named last_insert_id() or 
> mysql_insert_id() to retrieve the last insert id. How to retrieve 
> the last insert id of particular table using PEAR DB? I couldn't 
> find any function except sequence tables functions.
> >>
> >>Please let me know if you have any idea.
> >>
> >>Thanks
> >>
> >>-----
> >>
> >>Hardik K. Doshi
> >>Web Application Developer
> >>
> >>Institute of Design
> >>Illinois Institute of Technology
> >>350, North Lasalle Street
> >>Chicago, Illinois 60610
> >>
> >>312.595.4907 (direct)
> >>312.595.4901 (fax)
> >>
> >>
> >>
> >>-------------------------------------------------------
> >>This SF.Net email sponsored by: Free pre-built ASP.NET sites 
> including>>Data Reports, E-commerce, Portals, and Forums are 
> available now.
> >>Download today and enter to win an XBOX or Visual Studio .NET.
> >>http://aspnet.click-
> url.com/go/psa00100006ave/direct;at.asp_061203_01/01>>_______________________________________________
> >>chiPHPug-discuss mailing list
> >>chi...@li...
> >>https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss
> >>
> >>    
> >>
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email sponsored by: Free pre-built ASP.NET sites 
> including>Data Reports, E-commerce, Portals, and Forums are 
> available now.
> >Download today and enter to win an XBOX or Visual Studio .NET.
> >http://aspnet.click-
> url.com/go/psa00100006ave/direct;at.asp_061203_01/01>_______________________________________________
> >chiPHPug-discuss mailing list
> >chi...@li...
> >https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss
> >
> >
> >  
> >
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-
> url.com/go/psa00100006ave/direct;at.asp_061203_01/01_______________________________________________
> chiPHPug-discuss mailing list
> chi...@li...
> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss
>