I've had a script running on a Linux server (FreeBSD PHP 4.4.1) for over 6 months and I have just stated to get this error.
The script runs ok on my local computer (Windows and PHP 5) and also another server (Linux and PHP 4.3.11).
I've Googled for this error and checked both php.net and apache.org but can't find any references to the error number.
Any pointers would be appreciated.
bob
For info the section of code that appears to fail is the result of of a form update (the input of new employees works ok as does the input form itself which is part of the same PHP script).
Quote:
$employee=empees();
if ($_POST[update]=="Update") {
for ($i=0;$i< count($employee);$i++){
$em="em".$employee[$i][0];
if ($employee[$i][3]!=$_POST[$em]){
$query = "UPDATE employee SET email='".$_POST[$em]."' WHERE payno='".$employee[$i][0]."'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$employee[$i][3]=$_POST[$em];
echo "<br> ".$employee[$i][1]." has been updated";
}
}
echo "<table>";
for ($i=0;$i< count($employee);$i++){
$pw="pwd".$employee[$i][0];
if ($_POST[$pw]){
$password=getpass();
$query = "UPDATE employee SET password='".md5($password)."' WHERE payno='".$employee[$i][0]."'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$employee[$i][3]=$_POST[$em];
echo "<tr><td>".$employee[$i][0]."</td><td> ".$employee[$i][1]."</td><td> new Password is </td><td>".$password. "</td></tr>" ;
}
}
echo "</table>";
for ($i=0;$i< count($employee);$i++){
$del="del".$employee[$i][0];
if ($_POST[$del]){
$deldate=date("Ymd",strtotime("last Saturday")) ;
$query = "UPDATE employee SET dateleft='".$deldate."' WHERE payno='".$employee[$i][0]."'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$employee[$i][3]=$_POST[$em];
}
}
}
function empees()
{
$i=0;
$query="SELECT * FROM employee ORDER BY payno";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($line = mysql_fetch_array($result, MYSQL_NUM)){
$employee[$i][0]=$line[0];
$employee[$i][1]=$line[1];
$employee[$i][2]=$line[2];
$employee[$i][3]=$line[3];
$employee[$i][4]=$line[5];
$i++;
}
return $employee;}
Linear Mode
