MySQL error...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



	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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux