[SOLVED] help with dropdown list

[pooker]

I want a dropdown list to display the information from my sql database, that way when it reads a table it will display that information in the dropdown menu.  The dropdown menu displays but no information displays, there is data in the database also.  I have them saved as char's with max of 50.

 

<?php

 

include('config1.php');

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

$list = mysql_query("SELECT value,title FROM $db_name");

?>

 

 

<form action="action.php" name="form1" method="post">

<select name="option">

 

<?php

 

while ($row_list = mysql_fetch_assoc($list)) {

?>

<option value="<?php echo $row_list['value'] ?>">

<?php echo $row['title'] ?></option>;

<?php

}

?>

</select>

<input type="submit" name="Submit" value="select">

</form>

 

 

 

[.josh]

$list = mysql_query("SELECT value,title FROM $db_name");

 

change $db_name to your table name.

[pooker]

Thanks,    I feel stupid, gotta start soemwhere I guess.  :-\