Take a look, i'm just gonna put up the javascript and the update function, the rest is just populating textboxes and stuff.
print"<td><input type=submit name=update value=Update language=\"javascript\" onclick=\"opener.location.reload(); self.close()\" ></td>";
print"</tr>";
print"</table>";
print"</form>";
}
}
}
//leaving out the names of databases just for my own pref
function update($up)
{print"UPDATE";
$db=@mysql_connect("") or die(mysql_error());
mysql_select_db("",$db)or die(mysql_error()) ;
//if($up[status]=='Normal')
// {
if($up[status]=='Normal')
{
mysql_query("UPDATE time_work
SET date='$up[date]',
status='$up[status]',
hours='$up[hours]',
project='$up[project]',
activity='$up[activity]',
rdproj='$up[rdproj]',
comments='$up[comments]'
WHERE id='$up[id]'",$db);
}
else
{
$sql = "INSERT INTO time_off (uname,date,status,hours,comments) VALUES (\"$up[uname]\", \"$up[date]\", \"$up[status]\", \"$up[hours]\",\"$up[comments]\")";
$select = "DELETE FROM time_work WHERE id='$up[id]'";
}
$result = mysql_query($sql)or die(mysql_error());
$res = mysql_query($select)or die(mysql_error());
unset($result);
unset($res);
mysql_close();
}
//if($up[status]!='Normal')
function time_off($up)
{print"TIME OFF";
$db=@mysql_connect("") or die(mysql_error());
mysql_select_db("",$db)or die(mysql_error()) ;
if($up[status]!='Normal')
{
mysql_query("UPDATE time_off
SET date='$up[date]',
status='$up[status]',
hours='$up[hours]',
comments='$up[comments]'
WHERE id='$up[id]'",$db);
}
else
{
$sql = "INSERT INTO time_work (uname,date,status,hours,project,activity,rdproj,comments)
VALUES (\"$up[uname]\", \"$up[date]\", \"$up[status]\", \"$up[hours]\", \"$up[project]\", \"$up[activity]\", \"$up[rdproj]\",\"$up[comments]\")";
$select = "DELETE FROM time_off WHERE id='$up[id]'";
}
//}
$result = mysql_query($sql)or die(mysql_error());
$res = mysql_query($select)or die(mysql_error());
unset($result);
unset($res);
mysql_close();
}
?>