This form is calling it's own page. I want to add a record to the sec_types 
table. What happens is that it increments the type ID (passing '' to 
auto_increment) but doesn't add the variable $txtSec_type. It prints the 
text after the INSERT INTO statement.
Changing the variable to a direct value (like VALUES('', 'testing') insert 
the word 'testing'. Why isn't it passing the variable value??


Martin S.

<form action="admin.php?whattodo=admin/sec_types&action=add" method="POST">
      <td><select name="lstSec_type">
           <option>New security type</option>
                  $sec_query = "select sec_types from sec_types";
                  $secquery_res = mysql_query($sec_query, $mysql_link);
                  while ($row = mysql_fetch_row($secquery_res)) {
                    print "<option>$row[0]</option>";
          </select>  </td>
      <td><input type="text" name="txtSec_type" size="5">  </td>
      <td><?print "<a 
      <td><?print "<a 
      <td><?print "<a 

      <? switch ($action) {
      case "add":
        $addquery ="INSERT INTO sec_types (id, sec_types) VALUES";
        $addquery .="('', '$txtSec_type')";
        $result = mysql_query($addquery, $mysql_link) or die("query failed, " . 
        print "<h3>Done.</h3>";
        print "<p>The security type $txtSec_type was added to database.</p>";

etc etc
etc etc

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to