printing tables

[wazza91]

hi i have this code here and i was wondering how i could make it print out the values from my database using a drop down menu.

i no this is probably very basic but im a real novice at php and sql.

 

 

<?php

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

mysql_select_db('charity_data');

$result = mysql_query('select * from donations');

?>

<select name="selectname">

<?php

$i = 0;

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

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

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

  $i++;

}

 

 

 

?>

 

 

 

 

</select>

[Rifts]

<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('charity_data');
$result = mysql_query('select * from donations');
?>

<select name="selectname">
<?php
while ($row = mysql_fetch_assoc($result)){
  
  echo "<option value='whatever'>".$row['databasefield']."</option>";


}
?>
</select>

[wazza91]

thanks but there is nothing showing up in the dropdown menu.