Hey thanks alot!!!!. I allready managed to finish it. :irock::weee:
Here is the code now:
Code: Select all
<div id="the_code">
<?php
$host = "localhost";
$user = "root";
$password = "";
$db = "db_rev00";
$table = "comp_info";
$con = mysql_connect($host,$user,$password);
mysql_select_db($db);
mysql_query("SET NAMES 'utf8'");
if(!empty($_POST["update"]))
{
mysql_query("UPDATE $table SET comp_id = '".mysql_real_escape_string($_POST["comp_id"])."', comp_code = '".mysql_real_escape_string($_POST["comp_code"])."', comp_name = '".mysql_real_escape_string($_POST["comp_name"])."', comp_abbr_name = '".mysql_real_escape_string($_POST["comp_abbr_name"])."', comp_address = '".mysql_real_escape_string($_POST["comp_address"])."', comp_tel = '".mysql_real_escape_string($_POST["comp_tel"])."', comp_fax = '".mysql_real_escape_string($_POST["comp_fax"])."', homepage_url = '".mysql_real_escape_string($_POST["homepage_url"])."', products = '".mysql_real_escape_string($_POST["products"])."', employee_num = '".($_POST["employee_num"])."', comp_accept = '".mysql_real_escape_string($_POST["comp_accept"])."', comp_max_accept = '".mysql_real_escape_string($_POST["comp_max_accept"])."', representative = '".mysql_real_escape_string($_POST["representative"])."', supervisor = '".mysql_real_escape_string($_POST["supervisor"])."' WHERE comp_code = '".mysql_real_escape_string($_POST["comp_code"])."'");
echo "<b>Record successfully updated.</b>";
}
$sw = 0;
$result = mysql_query("SELECT comp_code FROM $table");
echo "<form action='#' method='post'>
<b> ???? </b> <select name='comp_code'>";
While($row = mysql_fetch_assoc($result))
{
if($sw == 0){$comp_code = $row["comp_code"];$sw = 1;}
echo (!empty($_POST["comp_code"])&&$_POST["comp_code"]==$row["comp_code"])?"<option selected>".$row["comp_code"]."</option>":"<option>".$row["comp_code"]."</option>";
}
echo "</select>
<input type='submit' value=' SHOW ' name='show'>
</form>";
mysql_free_result($result);
$comp_code = empty($_POST["comp_code"])?$comp_code:$_POST["comp_code"];
echo "<form action='#' method='post'>
<table width='306' border='1' cellpadding='2' cellspacing='1' bordercolor='#000000' id='tbl_upd'>";
$result = mysql_query("SELECT * FROM $table WHERE comp_code = '$comp_code'");
while($row = mysql_fetch_assoc($result))
{
echo "<tr><td width='145' bgcolor='#2A00AA'><span class='style11'>?? ID (????????)</span></td>
<td width='145' align='center'><input type='hidden' name='comp_id' value='".$row["comp_id"]."'>".$row["comp_id"]."</td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>?????</span></td>
<td align='center'><input type='hidden' name='comp_code' value='".$row["comp_code"]."'>".$row["comp_code"]."</td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>??</span></td>
<td align='center'><input type='text' name='comp_name' value='".$row["comp_name"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>??</span></td>
<td align='center'><input type='text' name='comp_abbr_name' value='".$row["comp_abbr_name"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>??</span></td>
<td align='center'><input type='text' name='comp_address' value='".$row["comp_address"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>????</span></td>
<td align='center'><input type='text' name='comp_tel' value='".$row["comp_tel"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>FAX??</span></td>
<td align='center'><input type='text' name='comp_fax' value='".$row["comp_fax"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>??????</span></td>
<td align='center'><input type='text' name='homepage_url' value='".$row["homepage_url"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>????</span></td>
<td align='center'><input type='text' name='products' value='".$row["products"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>????</span></td>
<td align='center'><input type='text' name='employee_num' value='".$row["employee_num"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>?????????</span></td>
<td align='center'><input type='text' name='comp_accept' value='".$row["comp_accept"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>?????????</span></td>
<td align='center'><input type='text' name='comp_max_accept' value='".$row["comp_max_accept"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>????</span></td>
<td align='center'><input type='text' name='representative' value='".$row["representative"]."'></td></tr>
<tr><td bgcolor='#2A00AA'><span class='style11'>??????</span></td>
<td align='center'><input type='text' name='supervisor' value='".$row["supervisor"]."'></td></tr>";
}
echo "</table>
<p>
<input type='submit' name='update' value=' UPDATE '>
</p>
</form>";
mysql_free_result($result);
// }
// }
?>
</div>
Ok, so this one takes the values from the
comp_code cell, and upload them into that table for edditing.
Now I have a little trouble adding another dropt down list to do the same thing, but instead on
comp_code, I need another cell called
comp_abbr_name. The diference is that this one is text not integer. So can you help me a little bitt implementing this to work on the same table??!? Thanks in advance.