How to get/retrieve value from database MySQL which triggeres by select/option
value my html and php code on picture attached

```
<select name="blok" id="blok">
<option value="B01">B01</option>
<option value="B02">B02</option>
<option value="B03">B03</option>
</select>

<?php

require_once 'connect.php';

$query  = "SELECT brand FROM table WHERE blok = **(value from option)**";'

$result = $mysqli->query($query);'

$row    = $result->fetch_array();'

echo $row[brand];

?>

```