cK Posted June 5, 2003 Share Posted June 5, 2003 Hi, I know how to make a field in a table UNIQUE, but have no clue if it\'s possible to make 1 field on two (!) tables UNIQUE and how to do this! For example make sure the are no duplicates in the \"login\" data (= username) so never ever a client will login and get - by accident - the stuff of the supllier with the same login. Putting everything in one table would be a solution, however my current cms-system can\'t handle this. client_id | username | password | more clients stuff... supplier_id |username | password | more supllier stuff... Quote Link to comment https://forums.phpfreaks.com/topic/547-unique/ Share on other sites More sharing options...
shivabharat Posted June 5, 2003 Share Posted June 5, 2003 The only way to do that would be to search for match in the other table. Quote Link to comment https://forums.phpfreaks.com/topic/547-unique/#findComment-1843 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.