Not Inserting into DB

[Xtremer360]

I can't get my Add new Division form to submit to the database. Anyone see my issue?

 

<?php 
$e = <<<here
    <script src="./jscripts/scriptaculous/prototype.js" type="text/javascript"></script>
	<script src="./jscripts/scriptaculous/scriptaculous.js" type="text/javascript"></script>
	<script type="text/javascript" src="./jscripts/ajax.js"></script>
here;
switch ($_REQUEST['option']) {
	case 0:
		echo $e;
		?>
            <h1 class="backstage">Division Management</h1><br />
            <h2 class=backstage>Divisions :: <a href="#" onclick="ajaxpage('backstage_libs/division.php?option=1', 'content'); return false;">Add New</a></h2><br />
            <table width="100%" class="table1">
                <tr class="rowheading">
                    <td> </td>
                    <td>Name</td>
                </tr>
            <?php
            $query = "SELECT * FROM efed_list_divisions";
            $result = mysql_query ( $query ); 
            $rows = mysql_num_rows($result);
        
            if ($result) {
			$i = 0;
			while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
				$sClass = 'row2';
				if ($i++ % 2) $sClass = 'row1';
				printf ( "<tr class=\"%s\">", $sClass );
                    print "<td valign=\"top\" align=center width=35><a href=\"#\" onclick=\"ajaxpage('backstage_libs/division.php?option=2', 'content'); return false;\">Edit</a></td>";
                    printf ( "<td valign=\"top\">%s</td>", $row [name] );
                    echo '</tr>';
			}
			echo '</table>';
		} else {
			echo '<span>There are no divisions.</span><br />';
		}
		returnmain();
	break;
	case 1:
		echo $e;
		require_once('../backstagefunctions.php');
		?>
            <h1 class="backstage">Division Management</h1><br />
            <h2 class="backstage">Add New Division</h2><br />
            <form name="divisions" method="post">
                <input type="hidden" name="action" value="division" />
                <table width="100%" class="table2">
                    <tr>
                        <td width="120" class="rowheading" valign="center">Division Name:</td><td class="row3"><input type="text" name="name" class="fieldtext490"></td>
                    </tr>
                </table><br />
                <input type="hidden" name="newadded" value="true">
                <input type="submit" value="Save Division" class="button"></form><br />
                <form method="post"><input type="submit" value="Return to Division List" class="button200" name="return">
            </form><br />
            <?php
            returnmain();
        break;
	case 2:
		echo $e;
		require_once('../backstagefunctions.php');
		?>
            <h1 class="backstage">Division Management</h1><br />
            <h2 class="backstage">Edit Division</h2><br />
            <form name="editdivision" method="post">
                <table width="100%" class="table2">
                    <tr>
                        <td width="120" class="rowheading" valign="center">Division:</td><td class="row3"><input type="text" name="division" class="fieldtext490" value=""></td>
                    </tr>
                </table><br />
                <center>
                <input type="checkbox" name="deletedivision"><span class="table1heading">Delete Division?</span><br /><br />
                <input type="submit" value="Edit Division" class=button name="editdivision"><br /><br />
                <input type="button" value="Return to Divisions List" class="button200"><br /><br />
            </form>
		<?php
		returnmain();
	break;
}
    function division() {
	if ((!empty($_POST['newadded'])) && (!empty($_POST['divisions']))) {
            $name = mysql_real_escape_string($_POST['name']);
            $query = "INSERT INTO `efed_list_divisions` (name) VALUES ('".$name."')";
            if (mysql_query($query)) {
			//success
		} else {
			//fail
		}
	}
}
?>

[mrMarcus]

are you calling the division() function anywhere?  it will not execute if it's not being called.