Probably its very easy. just a little question.

[PerenSap]

Hello,

first im not english so please dont hate when ive wrote someting wrong..

well ive a little question. i made a drop down box and in this box i see (select * from naw) all de rows i have in 'naw'. i want to see all places i have my row called 'plaats' (db = ws2 -> naw -> row = plaats.)

<?php

 

 

mysql_connect('localhost', 'root', '');

 

 

mysql_select_db('ws2');

 

 

$result = mysql_query('SELECT * FROM naw');

while($row = mysql_fetch_array($result))

?>

 

 

<select name="hallo">

 

 

<?php

 

 

$i = 0;

 

 

while ($i < mysql_num_fields($result)){

 

 

  $fieldname = mysql_field_name($result, $i);

 

 

  echo '<option value="'.$fieldname.'">'.$fieldname.'</option>';

 

 

  $i++;

 

 

}

 

 

?>

 

</select>

[smerny]

i'm not sure i'm clear on what you want, but think you're looking for this

 

while ($row = mysql_fetch_array($result)){

  $fieldname = $row['plaats'];

  echo '<option value="'.$fieldname.'">'.$fieldname.'</option>';
}