From drop down list to the field

iimrii

Hi !

I have a web page and in that web page ther is a form...in that form ther is a drop down list

select name="select">
                        <option><?
mysql_connect("localhost", "xxx", "xxxx");
mysql_select_db("xxxxx");
$query = "SELECT clan FROM amx_regclans";
$result = mysql_query($query);

while($row = mysql_fetch_object($result)){
echo "<option value=\"$row->clan\">$row->clan</option>";
}
?></option>

ok there is also another input box.

code:--------------------------------------------------------------------------------

<input type="text" name="nick" maxlength="40" size="40">

so the thing i want is when the user selects from the drop down list the value is automatically entered to the input box

so when the user selects mumu from the dropdown box...at that moment the input box will be filled with value from the DB and whatever the uset wants to type next depends ont eh user.

is it possible to do that?

thanks in advance

The_Chancer

Yup it is possible to do that, but as it is client side - it isn't within the bounds of PHP - try Javascript onChange property....

function swapOver {
document.form1.textbox.value=document.form1.dropdown.value;
}

Something like that, just call it with the onChange property in the dropdown.

iimrii

i am confused???

The_Chancer

OK - the simple form for this....

<form name=form1>
<select name=sel onChange=swapStuff()>
<option>The options</option>
</select>
<input type=text name=targ value="">
</form>

Now is the javascript

put this inn the head part of your page

<script language=javascript>
<!--
function swapStuff() {
document.form1.targ.value=document.form1.sel.value;
}
//-->
</script>

The function basically says that when the select box (called SEL) is changed then make the value of the textbox (called TARG) equal to the select box value.

http://www.google.com - search for javascript onchange tutorials... there are loads out there...

iimrii

i have a question in my DB there is a table X and there is the field called nick....well from the php form that i make is it possible to put values from two different text fields into a row (nick is the field_

like this in db table X here is the field

NICK

and in my php page there is those two input text fields

Clan TAG:

Nick:

lets say the user enters information to ClanTAG and Nick so the out come is like this

Clan TAG : [MOMO]

Nick devil

so after submitting the form in the db Nick field it is stored like this

[MOMO] devil

is it possible to do that?

iimrii

my form is like this

<form action="regusers.php" method="post" name="form1">
                <table width="90%" height="191">
                  <tr> 
                    <td width="33%" height="39"><font color="#CCCCCC" size="2" face="Geneva, Verdana, Georgia"><strong>Choose 
                      Clan</strong> </font></td>
                    <td width="67%"><select name="select" onChange=swapStuff()>
                        <option><?
mysql_connect("localhost", "xxxx", "xxxxxx");
mysql_select_db("xxxxx");
$query = "SELECT clan FROM amx_regclans";
$result = mysql_query($query);

while($row = mysql_fetch_object($result)){
echo "<option value=\"$row->clan\">$row->clan</option>";
}
?></option>
                      </select></td>
                  </tr>
                  <tr> 
                    <td><font color="#CCCCCC" size="2" face="Geneva, Verdana, Georgia"><strong>Nick 
                      </strong><font size="1">(Include your clan tag)<font color="#CC3300" size="2">*</font></font></font></td>
                    <td><input type="text" name="nick" value="" maxlength="40" size="40"> 
                    </td>
                  </tr>
                  <tr> 
                    <td><font color="#CCCCCC" size="2" face="Geneva, Verdana, Georgia"><strong>Password:<font color="#CC3300">* 
                      <br>
                      </font></strong><font color="#CC3300"> <font size="1">(min 
                      3 max 10 char)</font></font></font></td>
                    <td><input type="text" name="pass" maxlength="10" size="29"></td>
                  </tr>
                  <tr> 
                    <td><font color="#CCCCCC" size="2" face="Geneva, Verdana, Georgia"><strong>Flag:</strong></font></td>
                    <td><select name="flags">
                        <option selected>h</option>
                      </select></td>
                  </tr>
                  <tr> 
                    <td><font color="#CCCCCC" size="2" face="Geneva, Verdana, Georgia"><strong>Access 
                      Flags: </strong></font></td>
                    <td><select name="aflags">
                        <option selected>z</option>
                      </select></td>
                  </tr>
                  <tr> 
                    <td><font color="#CCCCCC" size="2" face="Geneva, Verdana, Georgia"><strong>Time: 
                      </strong></font></td>
                    <td><select name="lastus">
                        <option selected>2003-05-14 11:11:11</option>
                      </select></td>
                  </tr>
                  <tr>
                    <td><input name="submit" type="submit" onMouseDown="MM_validateForm('nick','','R','pass','','R');return document.MM_returnValue" value="Register">

and my regusers.php is like this


 <?php
  // create short variable names
  $nick=$HTTP_POST_VARS['nick'];
  $pass=$HTTP_POST_VARS['pass'];
  $flags=$HTTP_POST_VARS['flags'];
  $aflags=$HTTP_POST_VARS['aflags'];
  $lastus=$HTTP_POST_VARS['lastus'];

  if (!$nick || !$pass || !$flags || !$aflags || !$lastus)
  {
     echo 'You have not entered all the required details.<br />'
          .'Please go back and try again.';
     exit;
  }

  $nick = addslashes($nick);
  $pass = addslashes($pass);
  $flags = addslashes($flags);
  $aflags = addslashes($aflags);
  $lastus = addslashes($lastus);

  @ $db = mysql_pconnect('localhost', 'xxx', 'xxxxx', 'xxxx);

  if (!$db)
  {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }

  mysql_select_db('boyem_com');
  $query = "INSERT INTO  amx_regusers (nick, pass, flags, aflags, lastus) VALUES ('".$nick."', '".$pass."', '".$flags."', '".$aflags."', '".$lastus."')"; 

  $result = mysql_query($query);

  if ($result) {

          echo  mysql_affected_rows().' Player inserted into database for clan tag registration now you can go and play in | F@NTASTiC | CS server :) '; 
      } else {

          echo "Query Failed: ".mysql_error();
          echo "<br />".$query;
      }
?>

The_Chancer

The short answer to your question is YES... it is possible..

The long answer is see concatenation of strings here

All you need is a . ....

$fieldx=$nick.$clantag;