{

$_db = getMysqli();

$_stmt = $_db->prepare("SELECT VendorName, VendorID FROM Vendors");

$_stmt->execute();

$_stmt->bind_result($s_VendorName, $i_VendorID);

while($_stmt->fetch())

{

$_value = "<tr>

<td>

".$s_VendorName."

</td>

<td>";

if(canEditVendors())

{

$_value = $_value."<a href='./vendor.php?reason=edit&vid=".$i_VendorID."' class='btn btn-info' role='button'><span class='glyphicon glyphicon-pencil'></span> Update/Change</a> ";

}

{

$_value = $_value."<a href='./vendor.php?reason=view&vid=".$i_VendorID."' class='btn btn-primary' role='button'><span class='glyphicon glyphicon-search'></span> View</a>";

}

$_value = $_value."</td></tr>";

echo $_value;

}

$_stmt->free_result();

$_db->close();