drop down menu and php

rjasper

:eek: 😕 [FONT=Verdana]i need help with drop down menu and php. the problem is i am trying to have the code work so that whoever wishes to add to the options given in the drop down menu can by choose add new option. the page seems fine and doesn't give me any errors but it doesn't seem to be adding the new option in the drop down menu list. can anyone help!!![/FONT]

bpat1434

:eek: 😕 And just what does your code look like?!?!?!

~Brett

rjasper

<?php

include("upalheader.inc");

$table = "RecType";

<! -- *****************************************

         start web page content

      *****************************************-->

<tr>

<td align='center' valign='middle' nowrap>



<table cellpadding='10' cellspacing='2' border='0' style='border:1px solid #345487' class='row2'>

	<tr>

	<td width="253" valign="middle">

	<div align="justify"><font color="#666666" size="2" face="Arial">

<b>Add Option Form</b></font></div></td>

  </tr>

</table>

<br>

<?php

if ($Submit) {




	$resultdupe = mysql_query("

	SELECT * 

	FROM $table

	WHERE rt_type='". $rt_type ."'

	",$db);



	$row = mysql_fetch_row($resultdupe);

	if ($rt_type==$row[1]){

	echo "Option \"$row[1]\" is already in use. Please try another.";

	}

else {

		$defaultrt_type=$rt_type;

	// process form





	$formdate =date("Y-m-d H:i:s"); 





	$sql = "INSERT INTO RecType (

		rt_type


		)



		VALUES (

		'$rt_type'

		)";









	$result = mysql_query($sql);



	echo "<br><br>";

	echo "<br><br><font color='#666666' size='2' face='Arial'>";

	echo "$formdate";

	echo "<br><br>";

	echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$rt_type has sucessfully been added.\n";

	echo "<br><br>";

	$rt_type = Null; 

//	$password = Null;  

//	$userlevel = Null;

//	echo "$rt_type"; 

	echo "<form name=\"formaf\" method=\"post\" action=\"editrectype_input.php\"><div align=\"center\"> 

                <input type=\"Submit\" name=\"Submit2\" value=\"Add New Option\">

              </div></form>";

	}



}





	if (!$Submit || $error) {



		echo $error;





	// display form

<tr>

<td align='center' valign='middle' nowrap>

<form name="formaf" method="post" action="editrectype_input.php">



<table cols="2" cellpadding='10' cellspacing='2' border='0' style='border:1px solid #345487' class='row2'>

<!-- 	<tr>

	<td colspan="2" valign="middle">

	<div align="justify"><font color="#666666" size="2" face="Arial">

	<strong>*</strong>Required fields</font></div></td>



          </tr> -->

          <tr> 

            <td width="90"><strong><font color="#666666" size="2" face="Arial"> 

              Add New Option</font><font color="#666666" size="2" face="Arial">: 

              </font></strong></td>

            <td width="350"><strong><font color="#666666" size="2" face="Arial"> 

              <input name="rt_type" type="text" id="rt_type"

		value="<?php

		echo $defaultrt_type;

		?>"

		size="35" maxlength="35"></font>

		<font color=#ff0000>

		<?php

		echo $errorrt_type;

		?>



              </font></strong></td>

          </tr>




        </table>

        <br>

        <table width="69%" border="0" align="left">

          <tr> 

            <td><div align="center"> 

                <input type="submit" name="Submit" value="Submit">

              </div></td>

            <td><div align="center"> 

                <input type="reset" name="Submit2" value="Reset">

              </div></td>

          </tr>

        </table>

      </form></td>

  </tr>

</table>

<?php

} // end if

<! -- *****************************************

         end the web page content

      *****************************************-->

<?php

include("cmifooter.inc");

bpat1434

[PHP] tags when you post code please... so much easier to read..... And strip the whitespace when you post your code too...

And are you seeing what I'm seeing?

name=\"Submit2\"

Yet you reference a posted variable "$Submit".... which is it? Submit2 or Submit?

~Brett

rjasper

Sorry about that. Does this help?

<?php
include("upalheader.inc");

$table = "RecType";

?>
<table width='500' border="0" bgcolor="ffffff">

<tr>

<td align='center' valign='middle' nowrap>

<table cellpadding='10' cellspacing='2' border='0' style='border:1px solid #345487' class='row2'>

	<tr>

	<td width="253" valign="middle">

	<div align="justify"><font color="#666666" size="2" face="Arial">

<b>Add Option Form</b></font></div></td>

  </tr>

</table>

<br>

<?php

if ($Submit) {

	$resultdupe = mysql_query("

	SELECT * 

	FROM $table

	WHERE rt_type='". $rt_type ."'

	",$db);



	$row = mysql_fetch_row($resultdupe);

	if ($rt_type==$row[1]){

	echo "Option \"$row[1]\" is already in use. Please try another.";

	}

else {

		$defaultrt_type=$rt_type;

	// process form

	$formdate =date("Y-m-d H:i:s"); 


	$sql = "INSERT INTO RecType (

		rt_type


		)



		VALUES (

		'$rt_type'

		)";

	$result = mysql_query($sql);

	echo "<br><br>";

	echo "<br><br><font color='#666666' size='2' face='Arial'>";

	echo "$formdate";

	echo "<br><br>";

	echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$rt_type has sucessfully been added.\n";

	echo "<br><br>";

	$rt_type = Null; 

//	$password = Null;  

//	$userlevel = Null;

//	echo "$rt_type"; 

	echo "<form name=\"formaf\" method=\"post\" action=\"editrectype_input.php\"><div align=\"center\"> 

                <input type=\"Submit\" name=\"Submit2\" value=\"Add New Option\">

              </div></form>";

	}


}

	if (!$Submit || $error) {

		echo $error;

// display form

<tr>

<td align='center' valign='middle' nowrap>

<form name="formaf" method="post" action="editrectype_input.php">



<table cols="2" cellpadding='10' cellspacing='2' border='0' style='border:1px solid #345487' class='row2'>

          <tr> 

            <td width="90"><strong><font color="#666666" size="2" face="Arial"> 

              Add New Option</font><font color="#666666" size="2" face="Arial">: 

              </font></strong></td>

            <td width="350"><strong><font color="#666666" size="2" face="Arial"> 

              <input name="rt_type" type="text" id="rt_type"

		value="<?php

		echo $defaultrt_type;

		?>"

		size="35" maxlength="35"></font>

		<font color=#ff0000>

		<?php

		echo $errorrt_type;

		?>



              </font></strong></td>

          </tr>

         </table>

        <br>

        <table width="69%" border="0" align="left">

          <tr> 

            <td><div align="center"> 

                <input type="submit" name="Submit" value="Submit">
              </div></td>
            <td><div align="center">
                <input type="reset" name="Submit2" value="Reset">
              </div></td>
          </tr>
        </table>
      </form></td>
  </tr>
</table>

<?php
} // end if
?>

rjasper

Yea I see...I'm sorry but I am new at this and I really have no past training in PHP or MySQL. My boss sort of just gave me this project to do and sort of just figure it out on my own. I am trying to understand how that all works when the variable is $Submit but then it's really not used like that anywhere else. Instead it's used just as Submit.

I just changed it but the drop down list still won't add the option. Am I being clear as to what I need help with here? Please let me know if I'm being unclear.

rjasper

And what does this mean? I am assuming it's a SQL statement but can't seem to understand what it's role is in the code:

WHERE rt_type='". $rt_type ."'

bpat1434

Well, nothing does you better than reading up on mySQL queries in the mySQL manual and string concatenation in the PHP manual.

~Brett

rjasper

where can i find all this information?

bpat1434

mySQL Documentation
PHP Documentation

~Brett

rjasper

Thanks for the links. I was looking there but I guess I should start from the beginning and take it from there. Thanks.