I have been using a PHP page to update a database table for a
long time now. Unfortunately, I have noticed that frequently when I
perform an update I get back an error saying "Table 'tablename' doesn't
exist". This is becoming more and more annoying. The table obviously
exists as the page that I hit the update button on is populated from
this same page. Additionally, if I backout and reload the page most of
the time it will work. Any help would be greatly appreciated.
Mysql 3.23.49
PHP 4.2.3
<?php require_once('useraccounts.lib.php');
session_start();
if (!isset($_SESSION['valid_user']))
{
echo "You must be logged in to use this application. <br>";
$return_url = $_SERVER['PHP_SELF'];
session_register("return_url");
echo "Please <a href=\"../sa_login.php\"> login</a> now. <br>";
exit();
} else {
$sbcuid = $valid_user;
}
while(isset($entry[0])) {
$tmp = $entry[0];
$update = "UPDATE accounts SET ctime=NOW() WHERE id_sys='".$tmp."'";
$results = mysql_query($update, $Prod) or die(mysql_error());
array_shift($entry);
}
mysql_select_db($database, $Prod);
$query = "SELECT `id_sys`, atime, gid, shell FROM accounts WHERE atime
IS NOT NU
LL AND ctime IS NULL ORDER BY rtime ASC";
$result = mysql_query($query, $Prod) or die(mysql_error());
?>
<html>
<head>
<title>SBCLD User Account Request System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#CCCCCC">
<p align="center"><font color="#0033CC"
size="6"><strong>Administration</strong>
</font></p>
<p align="center"><font size="4">Here are the details for the accounts
approved
and pending creation:</font></p>
<p align="center">
<form method=post action="account_details.php">
<table width="90%" bgcolor="#CCCCCC" cellspacing="0">
<tr bordercolor="#0000CC">
<td width="20%" height="23"><div align="center"><font
color="#0000CC" size="
3">Requesting
User</font></div></td>
<td width="10%" valign="top"><div align="center"><font
color="#0000CC">Syste
m</font></div></td>
<td width="10%" valign="top"><div align="center"><font
color="#0000CC">Prima
ry Group</font></div></td>
<td width="10%" valign="top"><div align="center"><font
color="#0000CC">D
efault Shell</font></div></td>
<td width="30%" valign="top"><div align="center"><font
color="#0000CC">Reque
st Time</font></div></td>
<td width="10%" valign="top"><div align="center"><font
color="#0000CC">C
ompleted</font></div></td>
</tr>
<?php
do {
$entry = $list['id_sys'];
$id = split('-', $list['id_sys']);
$sbcuid = $id[0];
$sys = $id[1];
if (isset($list['id_sys'])) {
echo "<tr><td width=\"20%\"><div
align=\"center\">".$sbcuid."</div></t
d>";
echo "<td width=\"10%\"><div
align=\"center\">".$sys."</div></td>";
echo "<td width=\"15%\"><div
align=\"center\">".$list['gid']."</div></
td>";
echo "<td width=\"15%\"><div
align=\"center\">".$list['shell']."</div>
</td>";
echo "<td width=\"30%\"><div
align=\"center\">".$list['atime']."</div>
</td>";
echo "<td width=\"10%\"><div align=\"center\"><input
name=\"entry[]\"
type=\"checkbox\" value=$entry></div></td></tr>";
}
} while ($list = mysql_fetch_assoc($result));
?>
</table>
<p align="center">Placing a check in the completed box will update the
databas
e entry for
this request with a completed time and remove this entry from this
page upon
clicking the Update button below.</p>
<div align="center">
<input type=submit value="Update">
</div>
</form>
</body>
</html>
Thanks in advance. This is really beginning to bug the crap out
of me.
Scott Nipp
Phone: (214) 858-1289
E-mail: sn4265@xxxxxxx
Web: http:\\ldsa.sbcld.sbc.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
