Jump to content


Photo

UNIQUE


  • Please log in to reply
1 reply to this topic

#1 cK

cK
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 05 June 2003 - 08:45 AM

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...

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 05 June 2003 - 09:26 AM

The only way to do that would be to search for match in the other table.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users