[RESOLVED] Dynamic Form list

abasel

I'm trying to get a dropdown menu where the options are made up from entries in my database.

Bellow is what I've tried but it only puts the first item in the list and the rest appear as normal text next to the dropdown box.

Am I approaching this correctly and if so what is wrong?

        <form name="form1" method="post" action="">
          <div align="right">
            <p>Past Thoughts<br>
              <select name="select">
                <?php
				include '../include/config.php';
				include '../include/opendb.php';
			    $query = "SELECT id, title, public FROM tbldevotional WHERE public='1' ORDER BY title DESC";
				$result = mysql_query($query) or die('Error : ' . mysql_error());
				while(list($id, $title, $public) = mysql_fetch_array($result, MYSQL_NUM))
				{
				?>					
                <option value="<?=$id;?>"><?=$title;?></option>

              </select>
				<?php
				}
				include '../include/closedb.php';
			?>
			</p>
            </div>
        </form>

esukf

The </select> tag is inside the while loop.

<form name="form1" method="post" action="">
<div align="right">
<p>Past Thoughts<br>
<select name="select">
<?php
include '../include/config.php';
include '../include/opendb.php';
$query = "SELECT id, title, public FROM tbldevotional WHERE public='1' ORDER BY title DESC";
$result = mysql_query($query) or die('Error : ' . mysql_error());
while(list($id, $title, $public) = mysql_fetch_array($result, MYSQL_NUM))
{
?>
<option value="<?=$id;?>"><?=$title;?></option>
<?php
}
include '../include/closedb.php';
?>
</select>
</p>
</div>
</form>

abasel

Oops... thanks, I suppose that the moral of the story is not to do this sort of thing late at night :-)

abasel

I currently have a page that displays the top public entry as follows
<?php
include '../include/config.php';
include '../include/opendb.php';
$query = "SELECT id, title, entry, public, date FROM tbldevotional WHERE public='1' ORDER BY id DESC";
$result = mysql_query($query) or die('Error, query failed');

$entry = mysql_fetch_array($result, MYSQL_ASSOC);
echo "<p align='center'><span class='devotionaltitle'>{$entry['title']} </span></p>" . 
 "{$entry['entry']}<p></p><p><span class='linkurl'>{$entry['date']}</span></p>";

echo "<hr>";

At the bottom of the page is the following form:

<form action="" method="post" name="form1" target="_self">
<div align="right">
<p>Past Thoughts<br>
<select name="select">
<?php
include '../include/config.php';
include '../include/opendb.php';
$query = "SELECT id, title, public FROM tbldevotional WHERE public='1' ORDER BY title DESC";
$result = mysql_query($query) or die('Error : ' . mysql_error());
while(list($id, $title, $public) = mysql_fetch_array($result, MYSQL_NUM))
{
?>
<option value="<?=$id;?>"><?=$title;?></option>
<?php
}
include '../include/closedb.php';
?>
</select>
<input type="submit" name="Submit" value="Submit">
</p>
</div>
</form>

What do I need to do to the form/page so that when the user selects a previous entry it goes to that page i.e. does something like:

devotional.php?id=3

abasel

Got it to work