I'm having some problems with my code. Instead of doing everything in one function, I've broken it into 2, one for updating each table. But the problem is while one function works the other fails to connect to the database upon submit. Any ideas. I'll post my code.
function update($up)
{
print"UPDATE";
print_r($up);
$db=@mysql_connect("localhost","root") or die("Failed to connect to database!");
mysql_select_db("nti_admin",$db)or die("Failed to connect to database!") ;
if($up[x]=='Normal')
{
print"$up[x]";
print"<br>";
print"Normal - Sick";
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]\")";
}
$res = mysql_query($sql)or die("Failed to submit query!");
print"<br>";
print_r($sql);
}
function update_time($up)
{
print"UPDATE TIME";
print_r($up);
$db=@mysql_connect("localhost","root") or die("Failed to connect to database!");
mysql_select_db("nti_admin",$db)or die("Failed to connect to database!") ;
if($up[x]=='Sick'||'Overtime Taken'||'Vacation'||'Bereavement'||'Time Off w/o Pay'||'Other'||'Stat Holiday')
{
print"$up[x]";
print"<br>";
print"Sick - 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]\")";
}
$result = mysql_query($sql)or die("Failed to submit query!");
print"<br>";
print_r($sql);
}
?>
Thanks in advance,
M
