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... 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. Link to comment https://forums.phpfreaks.com/topic/547-unique/#findComment-1843 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.