0

I have a xampp database user log in with username and password, but i want to send each user an ID after registration and this ID should auto increment in my database. at the moment i can only achieve this if i include a field on the registration form, but i do not want to have a field memberID on the form it should only be visible in the database. pls could someone hellp me out

2
Contributors
3
Replies
10
Views
4 Years
Discussion Span
Last Post by LastMitch
2

@onofej

Can you show the table that you created? I'm not sure what you are asking.

The table should look like this:

CREATE TABLE `member` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(24) NOT NULL,
`password` varchar(24) NOT NULL,
PRIMARY KEY (id)
);
Votes + Comments
thank you for your time
0

thanks, seeing your code i found out that i have to use alter table using your code doing an sql inside xampp
thanks for your time

0

@onofej

Can you click MARK solve, the reason is that if someone who has the same problem as you can look at this thread and see that the correct answer.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.