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

    require a query to get the output

    Asked by gowrisankar on December 07, 2016 at 02:04 AM

     describe user;

    +---------+-------------+------+-----+---------+-------+

    | Field   | Type        | Null | Key | Default | Extra |

    +---------+-------------+------+-----+---------+-------+

    | id      | int(1)      | NO   | PRI | 0       |       |

    | name    | varchar(20) | YES  |     | NULL    |       |

    | address | varchar(20) | YES  |     | NULL    |       |

    | class   | int(2)      | YES  |     | NULL    |       |

    | DOB     | date        | YES  |     | NULL    |       |

    | created | date        | YES  |     | NULL    |       |

    +---------+-------------+------+-----+---------+-------+

    describe marklist;

    +------------+-------------+------+-----+---------+-------+

    | Field      | Type        | Null | Key | Default | Extra |

    +------------+-------------+------+-----+---------+-------+

    | id         | int(1)      | NO   |     | 0       |       |

    | subject    | varchar(10) | YES  |     | NULL    |       |

    | markscored | int(2)      | YES  |     | NULL    |       |

    | outof    | int(2)      | YES  |     | NULL    |       |

    | userid     | int(2)      | YES  | MUL | NULL    |       |

    +------------+-------------+------+-----+---------+-------+

    these are the two tables given and from these two i require an out put to be as :

    +---------+-------+-------+--------+-------+-----------+-----------+

    |name  |class |biology| chemistry|physics| outoftotal | totalmarkscored  |percentage|

    +--------+-------+-------+---------+-------+--------+---------------+

    |arun    | 5  |  45  |  42  |  40 |  150  | 127  |84.6|

     kindly give me a query to get the above output using the two tables user and marklist

  • Profile Image
    JotForm Support

    Answered by Chriistian on December 07, 2016 at 03:58 AM

    Hi gowrinsankar,

     

    If you want to create forms with the above requirements, it is achievable in JotForm. All you need is to start building your forms by dragging and dropping fields from the form builder.

    Here are some helpful guide on how to create forms:

    How to create your first web form

    How to position fields in JotForm

    How to Manage Multiple Fields

     

    If you need further assistance, do let us know.
    Regards