When you change your password through this process, you will see the login screen the next time you boot. Usually, you would enter your password (because you just changed it), and then you will be back to an automatic login, if that's what you prefer.
If you now seem to have lost your users, you could try the Disk Utility (while booted to the installer disk), from the same menu as the Reset Password. Do both a Repair Disk, and a Repair Disk Permissions. Quit that, and shut down.
If a normal boot then does not get a login window, or the password is not accepted yet, reboot again to the installed DVD, and try the reset password one more time. If you still do not show any users available, then my choice would be to reinstall the OS X, using the archive and install option.
Someone else may offer an idea that you can use when booted to single-user mode, to try to check for valid users, but I don't know about those.