TP Registration

I have a database table that collects very basic from people who wish to register. It collects FIRST_NAME, LAST_NAME, EMAIL, PHONE. The person is then assigned MEMBER_NO, in essence a membership number. Right now, the membership number is the MySQL database row as MEMBER_NO which is sequentially numbered using a UNIQUE INDEX. The MEMBER_NO start at 1111. In order for the new member to know their MEMBER_NO, they are directed to a database table and they have find their name and their MEMBER_NO. I'd like that after they submit their information, to display on a new page a welcome message and the information they just submitted with their new MEMBER_NO in bold or highlighted text. I know this is probably SQL 101, but I can't figure out how to do it! BTW... The use of the website is 100% free and on my dime. The URL is https://www.jimhfl.com. I'm sure someone can help me figure this out. Thanks! Jim Hilf