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"
jabeen123
0
Newbie Poster
Recommended Answers
Jump to PostI 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.
All 2 Replies
StephNicolaou
32
Posting Whiz in Training
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.
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.