PHP and MySQL insert when register, what if register table success but pending table failed ▲▲▲!
I have 2 tables for user registration. 1 is user, and 2 is pending.
When a user submitted a register form, I have to use two insert and mysql_query() them.
Now I wanna know what if the second one failed? Which must be very disturbing. :-(
-----
PS: User and Email are both unique in the user table. No duplicate data allowed.
PHP and MySQL insert when register, what if register table success but pending table failed ▲▲▲!
===

I have 2 tables for user registration. 1 is user, and 2 is pending.
When a user submitted a register form, I have to use two insert and mysql_query() them.
Now I wanna know what if the second one failed? Which must be very disturbing. :-(
-----
PS: User and Email are both unique in the user table. No duplicate data allowed.