Jump to content

[SOLVED] Insert Record Error

Zergman

By Zergman
in PHP Coding Help

 Share

Recommended Posts

Zergman Regular Member

Zergman

Posted
Posted

Have a insert form on a page, when I go to submit it, I get this

 

Incorrect table name ''

 

Here's my code 

<?php require_once('Connections/cnt2tracker.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "myform")) {
  $insertSQL = sprintf("INSERT INTO ``data`` (flagentTID, level1, level2, level3, notes, tdate, flmanager, t2agent) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['flagentTID'], "text"),
                       GetSQLValueString($_POST['optone'], "text"),
                       GetSQLValueString($_POST['opttwo'], "text"),
                       GetSQLValueString($_POST['optthree'], "text"),
                       GetSQLValueString($_POST['notes'], "text"),
                       GetSQLValueString($_POST['tdate'], "date"),
                       GetSQLValueString($_POST['flmanager'], "text"),
                       GetSQLValueString($_POST['t2agent'], "text"));

  mysql_select_db($database_cnt2tracker, $cnt2tracker);
  $Result1 = mysql_query($insertSQL, $cnt2tracker) or die(mysql_error());

  $insertGoTo = "callDetail.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>TTV Tier 2 Call Tracker</title>
<script type="text/javascript">
function setOptions(chosen,selbox) {
// selbox assignment deleted

selbox.options.length = 0;
if (chosen == " ") {
  selbox.options[selbox.options.length] = new Option('Please Select',' ');
setTimeout(setOptions(' ',document.myform.optthree),5);

}
if (chosen == "1") {
  selbox.options[selbox.options.length] = new
Option('first choice - option one','11');
  selbox.options[selbox.options.length] = new
Option('first choice - option two','12');
setTimeout(setOptions('11',document.myform.optthree),5);
}
// repeat for entries in first dropdown list

if (chosen == "11") {
  selbox.options[selbox.options.length] = new
Option('first choice - option one - sub one','111');
  selbox.options[selbox.options.length] = new
Option('first choice - option one - sub two','112');
}
// repeat for all the possible entries in second dropdown list
}
</script>

 

And my page

<body>

<? include 'includes/header.inc.php'; ?>
<br />
details of incident<hr />

<form action="<?php echo $editFormAction; ?>" method="post" name="myform" id="myform">
  <table align="center">
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><div align="right">Agent TID :</div></td>
      <td><input type="text" name="flagentTID" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right" valign="top" nowrap="nowrap"><div align="right">Trouble :</div></td>
      <td><select name="optone" size="10"
onchange="setOptions(document.myform.optone.options
continued from previous line[document.myform.optone.selectedIndex].value,
continued from previous linedocument.myform.opttwo);">
<option value=" " selected="selected"> </option>
<option value="1">First Choice</option>
<option value="2">Second Choice</option>
<option value="3">Third Choice</option>
<option value="4">MY CHOICE</option>
</select>

<select name="opttwo" size="10"
onchange="setOptions(document.myform.opttwo.options
continued from previous line[document.myform.opttwo.selectedIndex].value,
continued from previous linedocument.myform.optthree);">
<option value=" " selected="selected">Please Select</option>
</select>

<select name="optthree" size="10">
<option value=" " selected="selected">Please Select</option>
</select></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right" valign="top"><div align="right">Notes :</div></td>
      <td><textarea name="notes" cols="50" rows="5"></textarea>      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"> </td>
      <td><input type="submit" value="Insert Incident" /></td>
    </tr>
  </table>
  <input type="hidden" name="tdate" value="" />
  <input type="hidden" name="flmanager" value="" />
  <input type="hidden" name="t2agent" value="" />
  <input type="hidden" name="MM_insert" value="myform" />
</form>
<p> </p>
</body>

 

Never seen this error before and I can't seem to figure out whats wrong.  Page loads just fine, but it errors when I click submit.

 

Thanks in advance

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.