Member Avatar for zatie

i want to know simple coding how to check duplicate record.

  • 3 Contributors
  • 4 Replies
  • 49 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for somedude3488

in a database or what?

Member Avatar for zatie

yes..in database

Member Avatar for somedude3488

use 'unique' on the column in the database. it won't allow the same data twice in that column.

Member Avatar for buddylee17

Use SELECT DISTINCT in the query. This will discard duplicate rows. It is better to set constraints like mentioned above to eliminate duplicates from being inserted though.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.