John,
Big thank you! for your help. I had been trying out
the mysql_insert_id and was not having luck. It's
working great (with just a few more bumps to get
over).
--- John Holmes <[EMAIL PROTECTED]> wrote:
> Stuart Felenstein wrote:
>
> > But - I want to confirm, am I still using
> transacti
That made a world of difference! :) Thank you.
But - I want to confirm, am I still using transactions
even though I'm issuing individual query calls for
each insert.
And, if I can ask another question to the list :
In this line (from the second insert)
VALUES (null, LAST_INSERT_ID(), ..)";
Stuart Felenstein wrote:
If you see the code I have the begin , then the $query
follows. With both statements present, only the
second one does the insert. If I // or remove the
second, the first one takes.
Am I missing something here ?
Yep... you're missing a mysql_query() call for each query.
Stuart Felenstein wrote:
But - I want to confirm, am I still using transactions
even though I'm issuing individual query calls for
each insert.
Yes, that's the idea. Everthing between BEGIN and COMMIT/ROLLBACK is the
transaction.
In this line (from the second insert)
VALUES (null, LAST_INSERT_ID(