Hi just out of interest, How can I create unique "data sets", or rather, set a set of data as unique, to prevent another entry in the table that meets the same criteria,
for instance: id name surname address 1 john doe 1 street 2 mary jane 2 lane 3 john doe 3 ave 4 john doe 1 street As you can see row one and row 4 is identical in all 3 collumns, so how would I prevent a write like this to the table? sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php