What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Form to MySQL: Warning: mysql_numrows() expects parameter 1 to be resource

    Asked by Antonio 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.

    Thanks



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

    JotForm message parameters thanks
  • Profile Image
    JotForm Support

    Answered by EltonCris 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 http://pastebin.com/ 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 by gaceweb on November 24, 2013 at 06:35 PM

    Hi

    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

    Antonio

  • Profile Image
    JotForm Support

    Answered by jonathan 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.

    regards,