我已經(jīng)創(chuàng)建了一個(gè)表，并且正在從mySQL數(shù)據(jù)庫(kù)中提取數(shù)據(jù)。我已經(jīng)創(chuàng)建了3列，并希望采用第3列（建議數(shù)量）并將這些值復(fù)制到第4列的一行文本框中（訂購(gòu)數(shù)量），以便用戶可以對(duì)其進(jìn)行編輯。我該怎么做呢？$sql = "SELECT item_price.item_id, item_price.ITEM_NAME,suggested_qty,Price_itemFROM item_price JOIN suggested_item  ON item_price.ITEM_NAME = suggested_item.ITEM_NAME";$result = $conn->query($sql);?><tr><th> ID</th><th>Item Name</th><th>Suggested Quantity</th><th>Order Quantity</th><th>Total Cost ($)</th></tr><?phpwhile ($row = $result->fetch_assoc()) {    echo "<tr>";    echo "<td>" . $row['item_id'] ."</td>";    echo "<td>" . $row['ITEM_NAME'] . "</td>";    echo "<td>" . $row['suggested_qty'] . "</td>";}?></table>