Is storing email confirmation code in the database necessary?

In the php page can't we just generate a random number using php or md5, store it in a variable and then send it directly to the email address. Then check if the user has entered the correct code. I have two database tables one for unconfirmed users and other for confirmed so if the user is confirmed he will be added to the confirmed table and deleted from the table for unconfirmed users.