if column name is course and check this column to db mysql that if course is match with text field name course so not enter this record in mysql db for exmple i m entering already csc1 course and im type csc 1 again then show message "you are already enter this course number"

I would presonally advise you use a course number as a primary key.

Otherwise you will have to use string algorthims to remove the spaces as a delimiter, reduce all characters to lower case, etc.

Member Avatar for diafol

Agree, use an id, but if you're populating a courses table, then yes, you probably do need to be able to check for duplicates.

However, if you just want to select, best use a dropdown from existing entries.

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.