i created a table
CREATE TABLE emp_details (
id int(10) NOT NULL auto_increment,
projektnr varchar(100) NOT NULL default '',
hvorgang varchar(100) NOT NULL default '',
uvorgang varchar(100) NOT NULL default '',
soll varchar(100) NOT NULL default '',
status varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM
now the problem is im trying to insert the values for hvorgang and uvorgang for particular id thru application for that i created a text field and submit button im using php4.0.6
Code: Select all
$nr +=0;
if (isset($HTTP_POST_VARS['add'])){
mysql_query("INSERT into emp_details SET hvorgang = '".$HTTP_POST_VARS['newhvorgang']."' WHERE id = $nr");
mysql_query("INSERT into emp_details SET uvorgang = '".$HTTP_POST_VARS['newuvorgang']."' WHERE id = $nr");
}thanks in advance