我有两张MySQL表,
学生= 150 (代表学生总数的行总数)
employer= 230 (代表雇主总数no的行总数)
全码
<?php echo mysqli_num_rows($studempl); ?>
$conn = new mysqli ('localhost', 'root', '', 'dashboard');
$studempl = $conn ->query ("SELECT (SELECT COUNT(*) FROM student) + (SELECT COUNT(*) FROM employer) FROM dual");
$tot_studempl = mysqli_num_rows($studempl);结果:1
我怎么才能解决这个问题?
我试着用
SELECT 'student' AS stdID, COUNT(*) FROM student
UNION
SELECT 'employer' AS emplID, COUNT(*) FROM employer*它显示结果= 2,
我也尝试使用::
SELECT (SELECT COUNT(*) FROM student) AS count1,(SELECT COUNT(*) FROM employer) AS count2 FROM dual*它显示结果= 1,
我想我的代码可能出了问题,我怎么能从学生和雇主那里得到全部数据,这样我才能查看数据并以分段方式显示?
150,230
发布于 2018-04-02 14:49:16
我在MySQL中用如下的查询对两个表进行了求和
SELECT ( (SELECT COUNT(*) FROM scheme.student) +
(SELECT COUNT(*) FROM scheme.employer)
) AS 'Column' ;在我的例子中,我使用了相同的表2次,该表有280行(280x2= 560)。
希望这对你有帮助
发布于 2018-04-02 15:35:53
您的第二个查询应该可以工作。
SELECT (SELECT COUNT(*) FROM student) AS count1,(SELECT COUNT(*)
FROM employer) AS count2 FROM dual* <-- make sure you remove (*)
// so it should be like this
SELECT (SELECT COUNT(*) FROM student) AS count1,(SELECT COUNT(*)
FROM employer) AS count2 FROM dual然后,只需获取数组以显示结果即可。
$sql = "SELECT (SELECT COUNT(*) FROM playlists) AS count1,(SELECT COUNT(*) FROM artists) AS count2 FROM dual";
if ($result=mysqli_query($con,$sql))
{
$row = mysqli_fetch_array($result);
var_dump($row); // just checking the raw array...
echo "<br />";
echo $row[0]. ", ". $row[1]; // got your results -> 150, 230
}
mysqli_close($con);此外,如果您替换+ to,则您首先要执行以下查询工作:
$sql = "SELECT (SELECT COUNT(*) FROM students), (SELECT COUNT(*) FROM employer) FROM dual";https://stackoverflow.com/questions/49613102
复制相似问题