php - 1 个查询中的 mysql SELECT * FROM 和 SELECT TIME_FORMAT

Question

我在一个查询中实现 mysql SELECT * FROM 和 SELECT TIME_FORMAT 时遇到问题。这是我的查询

$result = $db->query(
    "SELECT
        *
    FROM
        form_data
    ORDER BY
        id
    UNION ALL
    SELECT
       TIME_FORMAT(SEC_TO_TIME(UNIX_TIMESTAMP(NOW()) -

UNIX_TIMESTAMP(LastUpdated)),'%Hh %im') 从 表单数据 订购依据 ID” )；

我尝试使用此查询的代码:

while($row = $result->fetch_assoc())
{
    $id = $row['id'];
    $title = $row['title'];

    echo '<tr>
            <td>'.$row["id"].'</td>
            <td>'.$row["studentid"].'</td> 
            <td><b><a href="requestdetails.php?id=' . $id . '">' . $title . '</a></b></td>
            <td>'.$row["category"].'</td>  
            <td>'.$row["status"].'</td>
            <td>'.$row["LastUpdated"].'</td>
            <td>'.$row["TIME_FORMAT(SEC_TO_TIME(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(LastUpdated)),'%Hh %im')"].'</td>
          </tr>';
  }

我能知道我哪里出错了吗？

Answer 1

更正后的查询是:

SELECT *,
  TIME_FORMAT(SEC_TO_TIME(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(LastUpdated)),'%Hh %im') AS tt
FROM form_data
ORDER BY id