Getting error while integrating form with MySQL

  • Profile Image
    Asked on November 24, 2013 at 06:56 AM

    Jotform folks

    I just copy and the example provided and change all the parameters/string with my database information, but the following message has displayed:

    Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in line 33

    Below is the 33 in my file. "$resultcount = mysql_numrows($sqlsearch);


    Any help is greatly appreciated.


    This is a re-post of a comment on How to send Submissions to Your MySQL Database Using PHP

  • Profile Image
    Answered on November 24, 2013 at 08:15 AM

    Hi Antonio,

    Please provide to us the entire PHP codes so we can check it further. You can paste it on and share with us the URL. Your line 33 is fine, perhaps the error is connected to the other part of the codes which we need to look at. But first, try replacing mysql_numrows with mysql_num_rows, see if this helps.

    We'll await your reply. Thanks!

  • Profile Image
    Answered on November 24, 2013 at 06:35 PM


    I changed the mysq_numrows with mysql_num_rows and was getting the same problem and with someone's help things got better.

    The real problem that was causing the form being "rejected' was the aditional digit that Jotform has added after some labels, example "email3"....

    My suggestion: do not add any values after certain fields suchs as "email3'"

    Good product and is making my life easier. Now I can create sophisticated form and save in mysql


  • Profile Image
    Answered on November 24, 2013 at 07:54 PM

    Hi Antonio,

    Thank you for the added suggestion. We are also glad to know that all is good on your form.

    I will forward your suggestion and observation to our higher team support so they can have an evaluation if the suggestion is applicable and helpful.