I am trying to pull users for a php mailer script.
$sql = "SELECT email FROM emails WHERE status = 'new' LIMIT 1
I am able to pull up the users i want using the sql above, but i want to update the “status” column to done when it has sent the email, i have tried the below but its not pulling any records.
$sql = "SELECT email FROM emails WHERE status = 'new' LIMIT 1 UPDATE 'emails' SET 'status'=done WHERE new";