cruxaders Posted March 10, 2011 Share Posted March 10, 2011 How can i make a table where his userid will start in 100-000 so when someone will register.. his userid will be 100-000 and so on.. and for example i got 2 table.... Tabel 1 and table 2... Pk on table 1 is userid... and table 2 will also have a userid same in table 1.. so that if i need to call somethin in table 2.. i will compare the userid only.... Quote Link to comment Share on other sites More sharing options...
cruxaders Posted March 10, 2011 Author Share Posted March 10, 2011 i think its foreign key..but how can i make foreign key in other tables..im using phpmyadmin Quote Link to comment Share on other sites More sharing options...
cruxaders Posted March 10, 2011 Author Share Posted March 10, 2011 i attach the images below which will show u that how my table is.. wat i want is the UserID will be the foreign key in sallary table... because user UserID was in registration Table... so how can i have a UserID in salary table and they have a same value in registration table..please help me [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
fenway Posted March 11, 2011 Share Posted March 11, 2011 Why 100-? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.