[RESOLVED] Form Selection

queenbee

Here I have a form that displays all the users in my database. When I select a user to send a message to, the message always goes to the last user listed regardless of which username I chose. How do I have to form determine which username was selected?

<form action="<? $_SERVER['PHP_SELF']?>?mode=db" method="post" name="form_compose" onSubmit="return check(this);">
<table width="80%" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse" align="center">
<tr>
<td class="heading11" colspan=2>Compose Mail</td>

</tr>
<tr>

<td class="headingfont" width="150" nowrap>To</td>
<td><select name="to2" size="1"><option selected value=""> Select a User</option>
<option value="">---------<?php
while ($uemail = mysql_fetch_array($email)) {
$username = $uemail['username'];
$mail = htmlspecialchars($uemail['email']);
echo "<option value='$mail'>$username</option>\n";
}
?>
</option></select></td><td><input name="to" type="hidden" value="<?=$username?>">
</td>
</tr>

Blulagoon

I'm not really sure what you are doing here from this code snippet, but assume somewhere you are searching a mysql db.

This line of code

</option></select></td><td><input name="to" type="hidden" value="<?=$username?>">

sets the submitted variable $POST['to'] to the last username in the drop down menu NOT to the one you subsequently select, whilst the submitted variable $POST['to2'] should contain the selected email you require.

There are two ways round this. After you test to see if the form has been submitted, you can do a search for username in the db where email address is $_POST['to2'] or you can use javascript to update the value in your hidden field in the line quoted above before the form is submitted. I would do the former as I don't profess to know very much about javascript.

HTH - Blu

queenbee

Thank you for your help, I somewhat understand what you are saying. Yes, I know my code is pulling the last name listed in the database, but I need to know how to have the code pull the name selected in the selection box.

Houdini

Well first of all you need to connect to the database server then select the database. I see you running a query but nowhere do I see an include that might have connected to the database nor to select the database. Neither do I see a query for mysql_fetch_array() to work with.

Blulagoon

queenbee wrote:
Thank you for your help, I somewhat understand what you are saying. Yes, I know my code is pulling the last name listed in the database, but I need to know how to have the code pull the name selected in the selection box.

PHP works by interacting with the server. Once a page has loaded, you'd need to use javascript to dynamically change the content, or possibly something like XAJAX which puts PHP code within a javascript wrapper. Currently though, your selection box is set to give you the value of the variable $mail which is (I think) the email address not the username into the variable $_POST['to2'].

HTH - Blu

FWIW - I still think performing a query limited by
WHERE email=$_POST['to2']
on the form processing part of the script is your best way forwards.

queenbee

Thanks a bunch Blulagoon, I will try that next

thanks Houdini, I do have a query for mysql_fetch_array(), this was only a portion of my code, the portion where I believe the problem lies.