Trap Database errors

[Denness]

Hello

Please help

How does one trap a database error ( for eg rejection due to duplicate values) with php

Thanks

[nnichols]

you can use mysql_error() to access the detail of any error message returned from MySQL or mysql_errno() to access the error number returned by MySQL.

You can also use the '@' to stop the functions from echoing the errors to screen.

Hope this helps

[Denness]

Thanks for your reply.

however I am using an access database and I need to know when the error occurs so that I can pass on a message to the user