connect_errno > 0){ die('Unable to connect to database [' . $db->connect_error . ']'); } // get the commands from the queue - one or more will be removed $query = 'SELECT * FROM queue ORDER BY queue_id ASC'; if (!$result = $db->query($query)) { die('There was an error running the query [' . $db->error . ']'); } $line = $result->fetch_array(MYSQLI_ASSOC); if ($line) { echo "{$line['queue_command']}"; $query = "DELETE FROM queue WHERE queue_id = '{$line['queue_id']}'"; if (!$result = $db->query($query)) { die('There was an error running the query [' . $db->error . ']'); } } else { echo "0"; } // Free resultset and close connection mysqli_free_result($result); $db->close(); ?>