PHP pdo 带日期的复杂查询

Question

这里我有mysql数据库'track_aktivnosti'

现在我从jquery ajax获取id_akt的值。现在我需要比较 id_akt=22 的日期，因此我需要获取最低日期并得到如下查询:

$result = $conn->prepare("SELECT naziv FROM track_aktivnosti WHERE datum=(lowest date) AND id_akt=:id_akt");
     $result->execute(array(':id_akt' => $_POST['id_akt']));
     $result = $result->fetchAll(); 
.
.
.
after that again but with next date so like this:

$result = $conn->prepare("SELECT naziv FROM track_aktivnosti WHERE datum=(next lowest date) AND id_akt=:id_akt");
     $result->execute(array(':id_akt' => $_POST['id_akt']));
    $result = $result->fetchAll(); 

所以对我来说最大的问题是如何找到 id_akt 某些值的最低日期，并从那里得到 naziv、vrednost

有人有想法吗？

Answer 1

SELECT naziv, LOWER(datum) FROM track_aktivnosti
WHERE id_akt = id_akt

您需要查询更低的数据