Not inserting and validating

I thought getting this software and extensions would make things easier but I'm wrong.


Whenever I add that validation tool kit to validate a text field userCSRID to make sure it doesn't exist in the db, it doesn't work and nothing get inserted. I create a record set, then apply the validation server.

What I'm I doing wrong?

I have attach the file.


2: I have 10 records in my db and the result page shows only three records.

On your insert page the validation is attempting to validate the following variable:

$totalRows_CheckRepeat

The problem with the way you have implemented the validations is that this variable has not been set when the validation occurs at the top of the page. In order for this to work properly you will need to move the server validation code down further on the page. Line 14-28 on the insert page should be moved down to just before the insert that is currently on line 130. It must be the last thing before the insert in order for it to work properly.

As for the results page only showing three results what do you see when you test the recordset on this page? If you have any MySQL GUI type of tool you should run your sql in there as a test to see what results occur. You can also test out your results page by browsing directly to it without first visiting the search page, this should get it to load with the default where clause and none of the filtering occurring.

Thank you, problem rectified