Display array in list question

[Rayman3_tk]

Hi!

I've got a simple question, but I can't figure it out myself, so here it is: I want to display titles of various posts and replies into a list, until now, I've come up with this till now:

if ($type==admin) {

$selectquery = mysql_query("SELECT forumreply.RTitel FROM user,forumreply,forumpost WHERE forumreply.RID=$vw AND forumpost.ID=$vw AND forumreply.RAID=user.ID ORDER BY forumreply.ID");

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

$rtitel=$row["RTitel"];

echo ("<form name='form1' method='post' action=''>
Verwijder <select name='select'>
<option value='$rtitel' selected>$rtitel</option>
</select>
<input type='submit' name='Submit' value='Go'>
</form>");
}}

When I display this list with values, I get all the values/titles, but everything's displayed in it's own list. How do I get them all in one list? Tnx.

[ednark]

gah! your so close!

you need to move the <form> and the <select> outside of the loop... they only need to be written once...

if ($type==admin) {
    $selectquery = mysql_query("SELECT forumreply.RTitel FROM user,forumreply,forumpost WHERE forumreply.RID=$vw AND forumpost.ID=$vw AND forumreply.RAID=user.ID ORDER BY forumreply.ID");

echo ("
<form name='form1' method='post' action=''>
Verwijder <select name='select'>
    ");

while ( $row = mysql_fetch_array($selectquery) ) {
    $rtitel=$row["RTitel"];
    echo ("<option value='$rtitel' selected>$rtitel</option>\n");
} /// while

echo ("
</select>
<input type='submit' name='Submit' value='Go'>
</form>
    ");

} /// if  

[Rayman3_tk]

Thanks! I tried it, and it worked perfectly. You're Great! :p