Re: How to use LAST_INSERT_ID() or mysql_insert_id() ?

2002-07-29 Thread Gordon Burditt
I know this is an old query, but still, problems . . . I've tried these both, but something is amiss - probably my interpretation. Every time I try to use LAST_INSERT_ID() I get a complaint that the query has a problem. E.G., $qry=$qry.;select LAST_INSERT_ID(); will blow up on me every time

Re: How to use LAST_INSERT_ID() or mysql_insert_id() ?

2002-07-29 Thread Georg Richter
On Monday, 29. July 2002 06:33, databarn wrote: Hi, E.G., $qry=$qry.;select LAST_INSERT_ID(); will blow up on me every time I've evaluated $qry, and it works just fine until I append the piece that should let me recover the auto increment value that was created during the insert process.

How to use LAST_INSERT_ID() or mysql_insert_id() ?

2002-07-28 Thread databarn
Folk, I know this is an old query, but still, problems . . . I've tried these both, but something is amiss - probably my interpretation. Every time I try to use LAST_INSERT_ID() I get a complaint that the query has a problem. E.G., $qry=$qry.;select LAST_INSERT_ID(); will blow up on me every