www.hkvforums.com

Please can anybody help with the correct SQL validation code for < > and = . i will like to insert with php my admin. the idea of what i want is this . i have a form with 3 fields.( drop down menu . each contains 1 to 6. i want an error to pop up if the value the addition of values selected in the three field is higher than 6. thank you

You can use Form_CustomValidate server event for your Add/Copy Page (enable Server-side Validation in PHP panel). See server event and client script in help file.

You can also use "Row_Inserting" server event to validate the value. Return FALSE if you want to cancel the inserting process. Read "Server Events and Client Scripts" in the help file for further information.