我从同一个表中的2个DB列中提取数据,以 HTML格式填充下拉菜单.虽然我确实获得了两个数据,但我似乎无法用空格分隔它们.下面的代码是我这样做的一般尝试,但我尝试更改和省略空格的引号以及用单引号和双引号括起Firstname和lastname.但似乎没有任何效果.到目前为止我离开了：Firstnamelastname.

<?PHP
        //db connection
            MysqL_connect('localhost','root',"");
            MysqL_select_db('recy');

            $sql = "SELECT CONCAT(firstname,' ',lastname) From technicians";
            $result = MysqL_query($sql);

            echo "<select name='firstname','lastname'>";
            while ($row = MysqL_fetch_array($result)) {
                echo "<option value'" . $row['CONCAT(firstname,lastname)'] . "'>" . ucwords($row['CONCAT(firstname,lastname)']) . "</option>";
            }
            echo "</select>";
        ?>

任何建议或建议表示赞赏.

$sql = "SELECT CONCAT_WS(' ',firstname,lastname) as name From technicians";