mysql - 如何计算 SQL 中选定的行数

Question

我想计算从查询中选择了多少行以及选定的数据。

SELECT `student`.`student id` AS ID,
    `student unit enrolment`.`session`,
    `student unit enrolment`.`unit code`,
    `units`.`unit name`,
    `workshops`.`campus`,
    `workshops`.`location`,
    CONCAT (
        `teachers`.`first name`,
        " ",
        `teachers`.`last name`
        ) AS Tutor
FROM `student`,
    `student unit enrolment`,
    `units`,
    `workshops`,
    `teachers`
WHERE `student`.`student id` = `student unit enrolment`.`student id`
    AND `student unit enrolment`.`unit code` = `units`.`unit id`
    AND `student unit enrolment`.`unit code` = `workshops`.`unit code`
    AND `workshops`.`teacher id` = `teachers`.`staff id`;

Answer 1

试试这个:

$result = mysql_query(YOUR_QUERY_HERE);
mysql_num_rows($result);