Select Code to Download

SELECT *
FROM messages
WHERE recipient_id=? AND status='NR'

UPDATE messages
SET status='OK'
WHERE message_id = ?

$msg = "original message"; # assume this is from the prev message

...
INSERT INTO messages (message_id, recipient_id, sender_id,
                      message, date, status)
VALUES (?, ?, ?, ?, ?, 'NR')