Re: [PHP3] MySQL <-> Oracle8

Do this query: Select <your_sequence_name>.currval from dual; this will return the current value of the sequence. BTW if you replace currval with nextval you can cause the sequence to increment and the result will be the incremented value. Hope that helps Meir Kriheli MKsoft computer systems ----- Original Message ----- From: "Adam Powell" <adam@powlex.com> To: "Dieter Kneffel" <data@wap4.com>; "php-general" <php-general@lists.php.net>; <php3@lists.php.net> Sent: Tuesday, June 06, 2000 4:30 AM Subject: Re: [PHP3] MySQL <-> Oracle8 > > Try doing a MAX(ROW_ID) select, and using this as your ID... it will give > you the highest ID in the table which is a good replacement. > > Thanks, > Adam > > > > ----- Original Message ----- > From: Dieter Kneffel <data@wap4.com> > To: php-general <php-general@lists.php.net>; <php3@lists.php.net> > Sent: Sunday, June 04, 2000 5:39 PM > Subject: [PHP3] MySQL <-> Oracle8 > > > > I need to get the ID generated from a previous INSERT operation. > > > > Is there an equivalent PHP/Oracle8 function for 'mysql_insert_id()' > > using MySQL? > > If not, how can I make a simple workaround? > > > > > > Tnx, > > > > Dieter > > > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net > > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >