mysql_insert_id()

[graham bramley]

Hello All,
I'm trying to select a user from a select list, then insert that user into another table called transactions, then go onto my next page.

Easy eh!!
Well, yes that bit is! What is not easy is when I'm trying to retrieve what the recently generated transactionID is.

I have tried the mysql_inert_id() which works fine if I stay on the same page.

Any help would always be much appreciated.

Many Thanks

Graham