Hello,
I have a timesheet app. I use a small bit of javascript to open a tiny window to edit a record. The problem is that it works great in Internet Explorer, but in Netscape the form pops up, but the submit does not work. Is this because of the java. Heres' my code from the link on, be gentle, I'm new to this:
print"<td><input type=submit name=update value=Update language=\"javascript\" onclick=\"opener.location.reload(); self.close()\" ></td>";
print"</tr>";
print"</table>";
print"</form>";
}
}
}
function update($up)
{print"UPDATE";
$db=@mysql_connect(" or die(mysql_error());
mysql_select_db("nti_admin",$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("nti_admin",$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();
}
?>
Hopefully someone has some ideas,
M
