divadiva Posted January 8, 2009 Share Posted January 8, 2009 In the database I am working on have an Id field. Now, I want to have two fields One should be internal and other external for external users. Internal Id will have internal code for privacy purposes and external id will be something meaning for end users.I am not sure with this logic .But it is an end user requirement. My concern is how should I link external and internal id together.Is there any use of it? So they make somesense.Can someone guide me on this? As I am not sure how to do that? Link to comment https://forums.phpfreaks.com/topic/140059-logic-question/ Share on other sites More sharing options...
rhodesa Posted January 8, 2009 Share Posted January 8, 2009 usually, you have a users table with an ID (which is an auto incrementing integer) and a USER field, which is a unique field that has their username in it. the ID is what is used internally to link to other tables. while username is used to look up their ID Link to comment https://forums.phpfreaks.com/topic/140059-logic-question/#findComment-732795 Share on other sites More sharing options...
divadiva Posted January 8, 2009 Author Share Posted January 8, 2009 Its not sequence genrated Id.It is a normal field.I have a seperate field for sequence generated id.Its basically toolId.I want old tool_id(intenal users can view) and new tool_id(external user can view).Dont know how would they link with each other in php code. Any idea?Thanks in advance. Link to comment https://forums.phpfreaks.com/topic/140059-logic-question/#findComment-732801 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.