require a query to get the output

  • Profile Image
    gowrisankar
    Asked 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
    Chriistian
    Answered 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