Q
Q
qrc3dt5772018-05-06 22:21:47
MySQL
qrc3dt577, 2018-05-06 22:21:47

How to merge 2 MySQL tables and output data to table?

There are two tables users (id, username, FIO, uchebnaya_group) and rubezhnii_kontrol (this is where teachers grade students) (iduser, rk1, rk2, itog, sr_ball).
It is necessary to create a query that will display all users of a particular study group and the grade set by the teacher in the rubezhnii_kontrol table

Table
5aef554092af6399461646.png

Request:
$query =    "SELECT 
            surname,
            fullname,
            otchestvo
            FROM users
            WHERE nomber=237";
$res = mysqli_query($dbh, $query);

How to display the grades that the teacher gave to a particular user?
Table
5aef5566022d4166314000.png

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question