Have a look at the below options:
Option 1: Just added DISTINCT in SQL query
<select class="form-control" id="space" name="space">
<option value="--Select--">--Select--</option>
<?php
$select=mysqli_query($con,"select DISTINCT `Space` from clients");
while($menuz=mysqli_fetch_array($select)){
$filled =$menuz['Space'];
$valuez = array("C101","C102","C103","C104","C105","C106","C107","C108","W1","W2","W3","W4","W5","W6","W7","W8","W9","W10","W11","W12","F1","F2","F3","F4","F5","F6","F7","F8","F9","F10");
foreach($valuez as $value){
if($value != $filled){
?>
<option value="<?php echo $value;?>">
<?php echo $value; ?>
</option>
<?php
}
}
}
?>
</select>
OR
Option 2: Ignoring existing set of values from SQL query only using “NOT IN”. Here you can use prepared statement to avoid SQL injection. For demo purpose only, I had shown here a query with embedded input parameters.
<?php
$valuez = array("C101","C102","C103","C104","C105","C106","C107","C108","W1","W2","W3","W4","W5","W6","W7","W8","W9","W10","W11","W12","F1","F2","F3","F4","F5","F6","F7","F8","F9","F10");
?>
<select class="form-control" id="space" name="space">
<option value="--Select--">--Select--</option>
<?php
$select=mysqli_query($con,"SELECT DISTINCT `Space` FROM `clients` WHERE `Space` NOT IN ('". implode("', '", $valuez) ."')");
while($menuz=mysqli_fetch_array($select)){
$filled =$menuz['Space'];
?>
<option value="<?php echo $filled;?>">
<?php echo $filled; ?>
</option>
<?php
}
?>
</select>