using the autoincrement field ?

[habbardone]

Hi,
I want to use the autoincrement field in mysql
- which I have set up for prod_ref

When I do an INSERT - do I just ignore the prod_ref field ?
and if I do will it get incremented automatically ?

Secondly - how can I find the value of this field as I need to
send it as part of a email immediately after the INSERT.

any ideas ?

Thanks, David

[Roger_Ramjet]

Yes, just omit any ref and value for the autoinc field during the insert. You use mysql insert id to find out what it was afterwards.