<select class="form-control" name="storeselect" required="" size="1">
		<option value=''>
			Select Store
		</option><?php
		$servername = "localhost";
		$username = "root";
		$password = "";
		$db = "storeinfo";

		// Create connection
		$conn = new mysqli($servername, $username, $password, $db);

		// Check connection
		if ($conn->connect_error) {
		    die("Connection failed: " . $conn->connect_error);
		}

		                            $db = new mysqli($servername, $username, $password, $db);
		                                $queryusers = "SELECT * FROM `information` WHERE `storelist` !='Security' ORDER BY `storelist` ASC";
		                                $db = mysqli_query($db, $queryusers);
		                            while ( $d=mysqli_fetch_assoc($db)) {
		                                //checking and formatting the mailto code just in case any field is blank.
		                                $manager = $d['manager'];
		                                $director = $d['director'];
		                                $sdirector = $d['sdirector'];
		                                // if there is no manager then only email the director and senior director
		                                if ($manager == "none"){
		                                $email = $director."?CC=".$sdirector;}
		                                //if there is no director just email the manager and senior director
		                                elseif ($director == "none") {
		                                $email = $manager."?CC=".$sdirector;
		                                }
		                                else {
		                                // if all three emails exist run the standard email code
		                                $email = $manager."; ".$director."?CC=".$sdirector;
		                                }
		                                // list all stores in a dropdown with the id being the email code so it dynamically loads into the submit button
		                              echo "
		                            <option value ='".$d['storelist']."' title ='".$d['name']."' id='".$email."'>".$d['storelist']."</option>";
		                            }
		                            ?>
	</select>