php - MySQL:使用上一个查询的结果创建具有多个 SELECTS 的查询

Question

我想检索具有特定值的行数，但是这个值取决于在使用这个结果之前必须完成的查询

已知变量为adId，例如adId为32所以我想获取 requestFrom 的值，其中 adId = 32

简单:$result = SELECT requestFrom FROM myTable WHERE adId = 32

然后我得到计数​​:

SELECT COUNT(*) FROM myTable WHERE requestFrom = $result AND adId = $adId AND requestStatus = '1'

-我只想在一个查询中执行此操作(获取计数)

+----+--------+-------------+------+--------+
| id | userId | requestFrom | adId | status |
+----+--------+-------------+------+--------+
|  1 |     23 |          58 |   32 |      1 |
|  2 |     23 |          65 |   37 |      0 |
|  3 |     76 |          27 |   73 |      1 |
|  4 |     29 |          58 |   29 |      1 |

Answer 1

使用子查询得到这个

SELECT COUNT(*) FROM myTable 
WHERE requestFrom = (select requestFrom from myTable where adId = $adId ) 
AND adId = $adId AND requestStatus = '1'