如何在输入字段中显示查询结果的多个值？

Question

I have a query result.

    | id | name     |
    -----------------
    | 3  | candi    |
    | 4  | gedangan |
    | 11 | sidoarjo |

My problem is how to display my query result into a single input field.

<input type="text" name="tags" id="" value="Candi, Gedangan, Sidoarjo" /> 

This is my query.

<?php 
   $query = mysql_query("SELECT kecamatan.KECAMATAN_ID , kecamatan.KECAMATAN_NAMA
         FROM sumber_air a 
         JOIN sumber_air_kecamatan ON a.ID_SUMBER=sumber_air_kecamatan.ID_SUMBER
         JOIN kecamatan ON sumber_air_kecamatan.KECAMATAN_ID=kecamatan.KECAMATAN_ID
         WHERE a.ID_SUMBER = " . $_GET['id'] . "'
         GROUP BY kecamatan.KECAMATAN_ID");

while ($row = mysql_fetch_array($query)) {
     <input type=text name=tags value=<?=$row['KECAMATAN_NAMA'];?> />
}
?>

Answer 1

You could do this:

<?php 
    $query = mysql_query("SELECT kecamatan.KECAMATAN_ID , kecamatan.KECAMATAN_NAMA
       FROM sumber_air a 
       JOIN sumber_air_kecamatan ON a.ID_SUMBER=sumber_air_kecamatan.ID_SUMBER
       JOIN kecamatan ON sumber_air_kecamatan.KECAMATAN_ID=kecamatan.KECAMATAN_ID
       WHERE a.ID_SUMBER = " . $_GET['id'] . "'
       GROUP BY kecamatan.KECAMATAN_ID");

    $tags = '';

    //adds every "KECAMATAN_NAMA" to $tags, seperated by ", "
    while ($row = mysql_fetch_array($query)) {
        $tags .= $row['KECAMATAN_NAMA'] . ', ';
    }

    //rtim($tags, ', ') removes the last ", " from the tags
    echo '<input type="text" name="tags" value="' . rtrim($tags, ', ') . '"/>';
?>