Value flow problem

[Rayman3_tk]

Hi there!

I'm retrieving values from a Mysql database with the help of value named $idid in the following code:

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

echo ("<form name='deleteform' method='post' action='Forum2.php?vw=$vw'>Verwijder <select name='delreply'>");

while ( $row = mysql_fetch_array($selectquery) ) {
$rid=$row["ID"];
$rtitel=$row["RTitel"];

echo ("<option value='$rid' selected>$rtitel</option>\n");
}
echo ("</select> <input type='submit' name='Verzend' value='Go'></form>");

Now, when I display the output of this array, I get the right stuff, but It's displayed for about 6 or 7 or more times. What am I doing wrong?

Tnx 🙂

[mogster]

Don't you have one to many } ?
while ( $row = mysql_fetch_array($selectquery) ) {
$rid=$row["ID"];
$rtitel=$row["RTitel"];

echo ("<option value='$rid' selected>$rtitel</option>\n");
}
echo ("</select> <input type='submit' name='Verzend' value='Go'></form>");
}

Or am I missing something?

knutm

[Rayman3_tk]

Yes, you're right, that } is from an else { } statement that came before this piece of code 😉 I'll change it ok? 😃

[Rayman3_tk]

But my question remains....

[Rayman3_tk]

I've finally solved the problem! I had to remove the select from 'user' table in this string:

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

Thanks all 🙂