如何找到上次输入记录

Question

$stmt = $db->prepare('SELECT a.fname, a.lname, h.amount, h.subsidy, h.last_payment, h.balance 
                        FROM history AS h
                        INNER JOIN  
                        attendees AS a
                        ON a.attendeeid = h.attendeeid
                        WHERE a.attendeeid = :id
                        ORDER BY historyid DESC LIMIT 1)');
    $stmt->bindValue(':id', $id, PDO::PARAM_INT);
    $stmt->execute();
    $result = $stmt->fetchAll();

Answer 1

请提供两张表的结构好吗？我猜你的表包含日期列，或者类似的东西。

不管怎样，我会尝试这样的方法：

select * 
from (select a.attendeeid,max(h.id) 
      FROM history AS h INNER JOIN attendees AS a ON a.attendeeid = h.attendeeid
      group by a.attendeeid) as maxHistoryPerAttendee 

这样，您将拥有每个attendeeID的maximun历史id。我猜最大id是最后插入的行。