combobox problem

jinwan

i'm new to php.i'm doing a combobox which will show the related company name if the company ID was selected.but i'm having problem to insert the company id into mySQL database.can anyone please help?

jansky

let me guess

LoganK

Give us some code and we'll be glad to help...

bradgrafelman

Click here for a possibly related thread.

NOTE: Thread was found searching this board with the terms "combobox mysql" .

jinwan

here are part of the code.hope can get a solution.thanks

<?php
session_start();
require_once("../db_function.php");
require_once("../auth.php");
require_once('../admin.php');
//logout();

if (isset($POST['Submit'])&&$POST['Submit']=="Add")
{
$flag=0;
$SupplyChainID=$POST['SupplyChainID'];
$Description=$POST['Description'];
$RCompanyID1=$POST['RCompanyID1'];
$CompanyName1=$POST['CompanyName'];
$RCompanyID2=$POST['RCompanyID2'];
$CompanyName=$POST['CompanyName'];

connect();

$query="select SupplyChainID, RCompanyID1,RCompanyID2 from relationships where SupplyChainID='$SupplyChainID'and
RCompanyID1='$RCompanyID1' and RCompanyID2='$RCompanyID2'";
$result=mysql_query($query);
$num=mysql_num_rows($result);
if($num==0)

{
$flag=1;
?>
<script language="javascript">
alert("ERROR!Data not in database.")
</script>

<?php
}
else{

?>
<script language="javascript">
alert("The data already exist in database.")
</script>

<?php
$flag = 1;
}

if($flag == 0)
{
connect();
$query = "insert into relationships (SupplyChainID, RCompanyID1, RCompanyID2)
values ('$SupplyChainID','$RCompanyID1','$RCompanyID2')";
$result = mysql_query($query);
$ID = mysql_insert_id();

			if(!$result)
				 $flag = 1;	

			}

}

$ID1 =$_POST['ID'];
$xMatchCompanyID = $_POST['xMatchCompanyID'];
$xMatchCompanyID1=$_POST['xMatchCompanyID'];
//$CompanyID = $_POST['CompanyID'];

connect();
$query1 = "select ID, Description from supply_chain order by Description";
$result1 = mysql_query($query1);
$num1 = mysql_num_rows($result1);

$queryUpperEntity = "select xMatchCompanyID, CompanyName from customers order by xMatchCompanyID";
$resultUpperEntity= mysql_query($queryUpperEntity);
$numUpperEntity= mysql_num_rows($resultUpperEntity);

$queryLowerEntity = "select xMatchCompanyID, CompanyName from customers order by xMatchCompanyID";
$resultLowerEntity = mysql_query($queryLowerEntity);
$numLowerEntity = mysql_num_rows($resultLowerEntity);

</p>
<style type="text/css">

</style>

<form name="form" method="post" action="add_supplychain_form.php">
<p align="center" class="style13 style1"><strong>Supply Chain Relationship </strong></p>
<p align="center" class="style13"> </p>
<p align="center" class="style13"> </p>
<table width="71%" border="2" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#CCFFFF">
<td width="45%" height="45" bordercolor="#FFFFFF" bgcolor="#FFFFCC"><span class="style12">Supply Chain : </span></td>
<td bgcolor="#FFFFCC"><select name="SupplyChainID" id="ID1" onChange="change(this);">
<?php
$flag = 0;
while($row = mysql_fetch_array($result1))
{
if($flag == 0)
{
$SupplyChainID = $row['ID'];
$flag = 1;
}

	if($row['Description'] == $Description)
		echo "<option value='".$row['Description']."' selected>".$row['ID']."</option>";
	else
		echo "<option value='".$row['Description']."'>".$row['ID']."</option>";
}

?>
</select></td>

<tr bgcolor="#CCFFFF">
<td width="45%" height="45" bordercolor="#FFFFFF"><span class="style12">Chain Description : </span></td>
<td width="55%" bgcolor="#CCFFFF"><input name="Description" type="text" id="Description" value="<?php echo $Description; ?>"></td>
</tr>

AcousticJames

Please place all code inside PHP tags to properly format and syntax color your code. Makes it a lot easier to read. Also, a more detailed description of the problem your having, the exact code that seems to be giving you the problem (as this is a lot of code, most of what could be removed for brevity), as well as your expected outcome. All these things will help us help you. Dumping all your code and expecting a solution is not the best thing to do.

<?php
session_start();
require_once("../db_function.php");
require_once("../auth.php");
require_once('../admin.php');
//logout();

if (isset($_POST['Submit'])&&$_POST['Submit']=="Add")
{
   $flag=0;
   $SupplyChainID=$_POST['SupplyChainID'];
   $Description=$_POST['Description'];
   $RCompanyID1=$_POST['RCompanyID1'];
   $CompanyName1=$_POST['CompanyName'];
   $RCompanyID2=$_POST['RCompanyID2'];
   $CompanyName=$_POST['CompanyName'];



connect();
   $query="select SupplyChainID, RCompanyID1,RCompanyID2 from relationships where SupplyChainID='$SupplyChainID'and
           RCompanyID1='$RCompanyID1' and RCompanyID2='$RCompanyID2'";
   $result=mysql_query($query);
   $num=mysql_num_rows($result);
   if($num==0)

   {
        $flag=1;
?>
<script language="javascript">
alert("ERROR!Data not in database.")
</script>

<?php
	}
	else{

?>
<script language="javascript">
alert("The data already exist in database.")
</script>

<?php
$flag = 1;
}


   if($flag == 0)
			{
				connect();
				$query = "insert into relationships (SupplyChainID, RCompanyID1, RCompanyID2) 
							values ('$SupplyChainID','$RCompanyID1','$RCompanyID2')";
				$result = mysql_query($query);
			 	$ID = mysql_insert_id();

			if(!$result)
				 $flag = 1;	

			}

}

$ID1 =$_POST['ID'];
$xMatchCompanyID = $_POST['xMatchCompanyID'];
$xMatchCompanyID1=$_POST['xMatchCompanyID'];
//$CompanyID = $_POST['CompanyID'];

connect();
$query1 = "select ID, Description from supply_chain order by Description";
$result1 = mysql_query($query1);
$num1 = mysql_num_rows($result1);

$queryUpperEntity = "select xMatchCompanyID, CompanyName from customers order by xMatchCompanyID";
$resultUpperEntity= mysql_query($queryUpperEntity);
$numUpperEntity= mysql_num_rows($resultUpperEntity);

$queryLowerEntity = "select xMatchCompanyID, CompanyName from customers order by xMatchCompanyID";
$resultLowerEntity = mysql_query($queryLowerEntity);
$numLowerEntity = mysql_num_rows($resultLowerEntity);

 ?>


<script language="JavaScript">
function change(objCombo)
{	
	document.form.ID1.value = document.form.Description.value;
}
function change1(objCombo)
{	
	document.form.xMatchCompanyID1.value = document.form.CompanyName1.value;
}
function change2(objCombo)
{	
	document.form.xMatchCompanyID.value = document.form.CompanyName.value;
}
 </script>

</p>
<style type="text/css">
<!--
.style1 {font-size: x-large}
-->
</style>

<form name="form" method="post" action="add_supplychain_form.php">
<p align="center" class="style13 style1"><strong>Supply Chain Relationship </strong></p>
<p align="center" class="style13">&nbsp;</p>
<p align="center" class="style13">&nbsp;</p>
<table width="71%"  border="2" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#CCFFFF">
    <td width="45%" height="45" bordercolor="#FFFFFF" bgcolor="#FFFFCC"><span class="style12">Supply Chain : </span></td>
     <td bgcolor="#FFFFCC"><select name="SupplyChainID" id="ID1" onChange="change(this);">
	       <?php
  	$flag = 0;
	while($row = mysql_fetch_array($result1))
	{
		if($flag == 0)
		{
			$SupplyChainID = $row['ID'];
			$flag = 1;
		}

	if($row['Description'] == $Description)
		echo "<option value='".$row['Description']."' selected>".$row['ID']."</option>";
	else
		echo "<option value='".$row['Description']."'>".$row['ID']."</option>";
}
  ?>
    </select></td>

  <tr bgcolor="#CCFFFF">
    <td width="45%" height="45" bordercolor="#FFFFFF"><span class="style12">Chain Description : </span></td>
	 <td width="55%" bgcolor="#CCFFFF"><input name="Description" type="text" id="Description" value="<?php echo $Description; ?>"></td>
    </tr>

Like that.

LoganK

I agree with James...always put your code in the [ PHP ] and [ /PHP ] tags (remove spaces)...other than that it looks like your code is fine, only problem I saw was with Javascript, and it's not really a problem, it's just that you're passing a variable to those functions change(), change1(), and change2() but you're not doing anything to that variable. Why even pass the variable? Just call change() and that's it.

Until you post a problem you're encountering, that's all I can help you with.

bradgrafelman

By the way, if you're wanting to change what the selected value of a combo box is, you need to change the "selectedIndex" value in JS to the index of the correct object (like an array in PHP).

jinwan

Thanks for the advice.i will take note of that.thanks for your help,i really appriciate it.Thanks.

LoganK

You're welcome & good luck!

(this message was delayed because "the administrator has specified that users can only post one message every 30 seconds"...they should have a feature like that only for "flagged" users, like those who purposely spam, not for legit users)