Is there a way to check the value in a column to make sure that no other rows have the same value in the same column?
EXAMPLE: A MySQL table has a UserCode column. Each row in the table must have a unique value for this column. If an attempt is made to enter a UserCode that already exists, then I want to show an error message.
In the UserCode column, I am using a custom edit function.
Any help would be appreciated…thanks!
Please refer demos/editing/server-validation.php.
It has working example how to apply unique and other business checks and show message on client.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!