-
Aaniket
I have a database with the column names as id(Auto Increament), name and address.
i want the query that it can update or insert using the same button.
it also has a search button, but i am not able to search it. could you please help me
thank you
-
John JotForm Support
Hello Aniket - The method discussed in the guide only sends the submission data to the database. So if you want to query from the said database, I think it should be done outside Jotform.
Now, if you mean you want to check the database for an existing data that matches the submission data, and if there is, you want to only update the record instead of adding a new one, I believe there is a custom PHP code provided for that here: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP . Please refer to STEP 4 on what code to use.