如何在mysql php中从数据库中回显一个未选中的选项值

Question

I want to echo or display an "unselected(2nd) option" from the db.

please help!!!

1st(selected) option where it will display the value "ACCEPTED"

<a type="button" class="btn btn-default btn-round btn-md" href="#">
   <?php echo $row['status'];?>
</a>  

2nd(unselected) option where it will display the value "PENDING"

<a type="button" class="btn btn-default btn-round btn-md" href="#">
   *HOW TO ECHO A VALUE IN HERE FROM THE DB?*
</a>  

PHP CODE(this is mysql query)

$stmt = $db->prepare('SELECT * FROM blog_members WHERE memberID = :memberID') ;
$stmt->execute(array(':memberID' => $_GET['id']));
$row = $stmt->fetch(); 

Answer 1

I think this is what you are looking for

if ($row['status'] == "PENDING") {
    echo '<a type="button" class="btn btn-default btn-round btn-md" href="#">
        PENDING
    </a>';
} else {
    echo '<a type="button" class="btn btn-default btn-round btn-md" href="#">
        ACCEPTED
    </a>';
}