Hi, I tried to retrieve values of enum but I get empty values. I can retrieve normal values. Can you help Please ?
this is the code
[php] <?php
session_start();
require ‘common.php’;
$connection = new mysqli($localhost, $dusername, $dpassword, $database);
if ($connection->connect_error) {
die("Connection failed: " . $connection->connect_error);
}
?>
<label><b>Blood Type</b></label>
<select name = "BloodType" id="BloodType">
<option>Blood Type</option>
<?php
if ($stmt = $connection->query(“select BloodType from patient”)) {
while ($r = $stmt->fetch_array(MYSQLI_ASSOC)) {
?>
<?php
echo $r[‘BloodType’];
?>
<?php
}
}
?>
</select>[/php]