hi i am new to php and mysql, i am experimenting with a script for saving data to mysql database. and fetch the data on other page, i managed to get both of them without any trouble.
But Here is the one problem. I added a additional input function to save the input data, but other input functions are working except the one i modified.!!
i added the value through phpmyadmin and it works for fetching that data, but can not added value through this script.(see below, i have put down the code)

i am using the latest wampserver.and the modified input is "$compny_name". i wanted to add a field to add company names, but it just dont save the value.
This script is a little big, maybe too big but any help would be appreciate. :(

<?php
   session_start();
   error_reporting(0);
   define('ADMIN_PASS', 'password');
   define('MAIN_SCRIPT', basename(__FILE__));
   $session_timeout = 3600*24*30;
   $mysql_server = 'localhost';
   $mysql_username = 'test@localhost';
   $mysql_password = '';
   $mysql_database = 'test';
   $username = 'admin';

   $labelHome = 'Home';
   $labelName = 'Product Name';
   $labelCompanyName = 'Company Name';
   $labelCreatedBy = 'Created by';
   $labelLastUpdate = 'Last update';
   $labelVisible = 'Visible';
   $labelHomePage = 'Home page';
   $labelViews = 'Views';
   $labelOrder = 'Order';
   $labelContent = 'Product Description';
   $labelURL = 'External URL';
   $labelExtraData = 'Supported OS';
   $labelTitle = 'Title';
   $labelDescription = 'Description';
   $labelKeywords = 'Keywords';
   $labelAction = 'Action';
   $labelNewPage = 'Add a Download';
   $labelCaption = 'Content Management System';
   $labelLogin = 'Login';
   $labelLogout = 'Logout';
   $labelEdit = 'Edit';
   $labelCopy = 'Copy';
   $labelDelete = 'Delete';
   $labelYes = 'Yes';
   $labelNo = 'No';
   $labelSave = 'Save';
   $labelCancel = 'Cancel';
   $labelUp = 'Up';
   $labelDown = 'Down';
   $labelOwner = 'Owner';
   $labelPlugins = 'Plugins';
   $labelUserName = 'Username:';
   $labelPassword = 'Password:';
   $admin_password = isset($_COOKIE['cmsadmin_pwd']) ? $_COOKIE['cmsadmin_pwd'] : '';


   if (empty($admin_password))

   {

      if (isset($_POST['admin_password']))

      {

         $admin_password = md5($_POST['admin_password']);

         if ($admin_password == md5(ADMIN_PASS))

         {

            setcookie('cmsadmin_pwd', $admin_password, time() + $session_timeout);

         }

      }

   }

   else

   if ($admin_password == md5(ADMIN_PASS))

   {

      setcookie('cmsadmin_pwd', $admin_password, time() + $session_timeout);

   }

   $authorized = ($admin_password == md5(ADMIN_PASS));

   if (!$authorized)

   {

      if (isset($_SESSION['cms_user']))

      {

         $authorized = true;

         $username = $_SESSION['cms_user'];

      }

   }

   $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '';

   $action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';

   $name = isset($_POST['name']) ? $_POST['name'] : '';

   $compny_name = isset($_POST['compny_name']) ? $_POST['compny_name'] : '';

   $content = isset($_POST['content']) ? $_POST['content'] : '';

   $url = isset($_POST['url']) ? $_POST['url'] : '';

   $extra_data = isset($_POST['extra_data']) ? $_POST['extra_data'] : '';

   $title = isset($_POST['title']) ? $_POST['title'] : '';

   $description = isset($_POST['description']) ? $_POST['description'] : '';

   $keywords = isset($_POST['keywords']) ? $_POST['keywords'] : '';

   $created_by = isset($_POST['created_by']) ? $_POST['created_by'] : '';

   $visible = isset($_POST['visible']) ? $_POST['visible'] : 0;

   $timestamp = date("y-m-d H:i:s", time());



   $plugins = array();

   if (file_exists('./plugins/'))

   {

      $handle = opendir('./plugins/');

      while ($item = readdir($handle))

      {

         if ($item != "." && $item != ".." && is_dir('./plugins/'.$item) && substr($item, 0, 1) != '_')

         {

            require_once('./plugins/'.$item.'/plugin.php');

            $plugins[$item] = $plugin;

         }

      }

      closedir($handle);

   }

   $db = mysql_connect($mysql_server, $mysql_username, $mysql_password);

   if (!$db)

   {

      die('Failed to connect to database server!<br>'.mysql_error());

   }

   mysql_select_db($mysql_database, $db) or die('Failed to select database<br>'.mysql_error());

   if ($action == 'login')

   {

      if (!$authorized && function_exists('usermanager_login'))

      {

         usermanager_login();

      }

      $action = '';

   }

   if ($authorized)

   {

      if (get_magic_quotes_gpc())

      {

         $content = stripslashes($content);

         $url = stripslashes($url);

         $name = stripslashes($name);

         $cname = stripslashes($cname);

         $extra_data = stripslashes($extra_data);

         $title = stripslashes($title);

         $description = stripslashes($description);

         $keywords = stripslashes($keywords);

         $created_by = stripslashes($created_by);

      }

      $content = mysql_real_escape_string($content);

      $url = mysql_real_escape_string($url);

      $name = mysql_real_escape_string($name);

      $cname = mysql_real_escape_string($cname);

      $extra_data = mysql_real_escape_string($extra_data);

      $title = mysql_real_escape_string($title);

      $description = mysql_real_escape_string($description);

      $keywords = mysql_real_escape_string($keywords);

      $created_by = mysql_real_escape_string($created_by);

      $sql = "CREATE TABLE IF NOT EXISTS CMS_PAGES (id INT UNSIGNED NOT NULL AUTO_INCREMENT,

              category_id INT NOT NULL, 

              name VARCHAR(255) NOT NULL, 

              content TEXT NOT NULL, 

              home tinyint(1) NOT NULL, 

              visible tinyint(1) NOT NULL, 

              create_date TIMESTAMP NOT NULL, 

              created_by VARCHAR(255) NOT NULL, 

              last_update_date TIMESTAMP NOT NULL, 

              last_update_by VARCHAR(255) NOT NULL, 

              views INT NOT NULL, 

              menu_index INT NOT NULL, 

              url VARCHAR(255), 

              cname VARCHAR(255),

              extra_data VARCHAR(255), 

              title VARCHAR(100), 

              description VARCHAR(255), 

              keywords VARCHAR(255), 

              seo_friendly_url VARCHAR(100), 

              PRIMARY KEY(id));";

      $result = mysql_query($sql, $db);

      if (!$result)

      {

         die('Invalid query: ' . mysql_error());

      }

      $sql = "CREATE TABLE IF NOT EXISTS CMS_SEARCH_WORDS (id INT UNSIGNED NOT NULL AUTO_INCREMENT,

              word VARCHAR(50) NOT NULL,

              PRIMARY KEY (id));";

      $result = mysql_query($sql, $db);

      if (!$result)

      {

         die('Invalid query: ' . mysql_error());

      }

      $sql = "CREATE TABLE IF NOT EXISTS CMS_SEARCH_WORDMATCH (page_id INT UNSIGNED NOT NULL,

              word_id INT UNSIGNED NOT NULL,

              PRIMARY KEY(page_id, word_id));";

      $result = mysql_query($sql, $db);

      if (!$result)

      {

         die('Invalid query: ' . mysql_error());

      }

      $upgrade = true;

      $result = mysql_query("show columns from CMS_PAGES");

      while ($data = mysql_fetch_assoc($result))

      {

         if ($data['Field'] == 'keywords')

         {

            $upgrade = false;

            break;

         }

      }

      if ($upgrade)

      {

         $sql = "ALTER TABLE CMS_PAGES ADD (title varchar(100),

                                            description varchar(255),

                                            keywords varchar(255),

                                            seo_friendly_url varchar(100));";

         $result = mysql_query($sql, $db);

         if (!$result)

         {

            die('Invalid query: ' . mysql_error());

         }

      }

      foreach($plugins as $pluginname=>$p)

      {

         if (isset($p['admin']['init']))

         {

            $fn_init = $p['admin']['init']['function'];

            $fn_init();

         }

      }

      if (!empty($action))

      {

         if ($action == 'delete')

         {

            $menu_index = 0;

            $sql = "SELECT * FROM CMS_PAGES WHERE `id` = '$id'";

            $result = mysql_query($sql, $db);

            if ($data = mysql_fetch_array($result))

            {

               $menu_index = $data['menu_index'];

            }

            $sql = "DELETE FROM CMS_PAGES WHERE `id` = '$id'";

            mysql_query($sql, $db);

            $sql = "DELETE FROM CMS_SEARCH_WORDMATCH WHERE `page_id` = '$id'";

            mysql_query($sql, $db);

            $sql = "UPDATE CMS_PAGES SET menu_index=menu_index-1 WHERE menu_index > '$menu_index'";

            mysql_query($sql, $db);

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'update')

         {

            $seo_friendly_url = strtolower($title);

            $seo_friendly_url = preg_replace("/[^a-z0-9_\s-]/", "", $seo_friendly_url);

            $seo_friendly_url = preg_replace("/[\s-]+/", " ", $seo_friendly_url);

            $seo_friendly_url = preg_replace("/[\s_]/", "-", $seo_friendly_url);

            $sql = "UPDATE CMS_PAGES SET `name` = '$name', `cname` = '$cname', `content` = '$content', `url` = '$url', `extra_data` = '$extra_data', `title` = '$title', `description` = '$description', `keywords` = '$keywords', `seo_friendly_url` = '$seo_friendly_url', `visible` = $visible, `last_update_date` = '$timestamp', ";

            if ($username == 'admin' && $created_by != '')

            {

               $sql .= "`created_by` = '$created_by', ";

            }

            $sql .= "`last_update_by` = '$username' WHERE `id` = '$id'";

            mysql_query($sql, $db);

            addToSearchIndex($id, $content);

            foreach($plugins as $pluginname=>$p)

            {

               if (isset($p['admin']['update']))

               {

                  $fn_update = $p['admin']['update']['function'];

                  $fn_update($id);

               }

            }

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'create')

         {

            if ($username != 'admin' || $created_by == '')

            {

               $created_by = $username;

            }

            $sql = "SELECT * FROM CMS_PAGES";

            $result = mysql_query($sql, $db);

            $menu_index = mysql_num_rows($result);

            $menu_index = $menu_index + 1;

            $sql = "INSERT CMS_PAGES (`category_id`, `name`, `cname`, `content`, `url`, `extra_data`, `title`, `description`, `keywords`, `visible`, `create_date`, `created_by`, `last_update_date`, `last_update_by`, `menu_index`) VALUES (0, '$name', '$cname', '$content', '$url', '$extra_data', '$title', '$description', '$keywords', $visible, '$timestamp', '$created_by', '$timestamp', '$username', $menu_index)";

            mysql_query($sql, $db);

            $id = mysql_insert_id();

            addToSearchIndex($id, $content);

            foreach($plugins as $pluginname=>$p)

            {

               if (isset($p['admin']['update']))

               {

                  $fn_update = $p['admin']['update']['function'];

                  $fn_update($id);

               }

            }

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'home')

         {

            $sql = "UPDATE CMS_PAGES SET `home` = 0";

            mysql_query($sql, $db);

            $sql = "UPDATE CMS_PAGES SET `home` = 1 WHERE `id` = '$id'";

            mysql_query($sql, $db);

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'moveup' || $action == 'movedown')

         {

            $sql = "SELECT * FROM CMS_PAGES WHERE `id` = '$id'";

            $result = mysql_query($sql, $db);

            $menu_index = 0;

            if ($data = mysql_fetch_array($result))

            {

               $menu_index = $data['menu_index'];

            }

            if ($action == 'moveup')

               $new_index = $menu_index - 1;

            else

               $new_index = $menu_index + 1;

            $sql = "UPDATE CMS_PAGES SET menu_index = $menu_index WHERE menu_index = '$new_index'";

            mysql_query($sql, $db);

            $sql = "UPDATE CMS_PAGES SET menu_index = $new_index WHERE id = '$id'";

            mysql_query($sql, $db);

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'logout')

         {

            session_unset();

            session_destroy();

            setcookie('cmsadmin_pwd', '', time() - 3600);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         {

            if (isset($_REQUEST['plugin']))

            {

               require('./plugins/'.$_REQUEST['plugin'].'/'.$action.'.php');

               exit;

            }

         }

      }

   }

   function addToSearchIndex($page_id, $content)

   {

      $sql = "DELETE FROM CMS_SEARCH_WORDMATCH WHERE page_id = '$page_id'";

      mysql_query($sql);

      $content = strtolower(html_entity_decode($content));

      $content = preg_replace('/&#?\w+;/', ' ', $content);

      if (!get_magic_quotes_runtime())

         $content = addslashes($content);

      $content = preg_replace('/\s+/', ' ', $content);

      $content = strip_tags($content);

      $content = preg_replace('/\W+/', ' ', $content);

      $words = preg_split('/\s+/', trim($content));

      $id_array = array();

      $index = 0;

      foreach ($words as $word)

      {

         if (strlen($word) < 2) continue;

         if (is_numeric($word)) continue;

         $sql = "SELECT id FROM CMS_SEARCH_WORDS WHERE word = '$word';";

         $result = mysql_query($sql);

         if (!$result)

         {

            die('Invalid query: ' . mysql_error());

         }

         $record = mysql_fetch_object($result);

         if (!$record || !$word_id = $record->id)

         {

            $sql = "INSERT INTO CMS_SEARCH_WORDS (word) VALUES ('$word');";

            mysql_query($sql);

            $word_id = mysql_insert_id();

         }

         $id_array[$index] = $word_id;

         $index++;

      }

      foreach ($id_array as $word_id)

      {

         $sql = "INSERT INTO CMS_SEARCH_WORDMATCH (`word_id`, `page_id`) VALUES ('$word_id', '$page_id');";

         mysql_query($sql);

      }

   }

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Aro Download manager</title>
<link href="../aro.ico" rel="shortcut icon">
<link rel="stylesheet" href="../cmsadmin.css" type="text/css">

<script type="text/javascript" src="../jquery-1.7.2.min.js"></script>

<script type="text/javascript" src="../ckeditor/ckeditor.js"></script>

<script type="text/javascript" src="../ckeditor/adapters/jquery.js"></script>

<script type="text/javascript">

$(document).ready(function()

{

   $('#editor').ckeditor({});

   $('ul.tabs').each(function()

   {

      var $active, $content, $links = $(this).find('a');

      $active = $($links.filter('[href="'+location.hash+'"]')[0] || $links[0]);

      $active.addClass('active');

      $content = $($active.attr('href'));

      $links.not($active).each(function ()

      {

         $($(this).attr('href')).hide();

      });

      $(this).on('click', 'a', function(e)

      {

         $active.removeClass('active');

         $content.hide();

         $active = $(this);

         $content = $($(this).attr('href'));

         $active.addClass('active');

         $content.show();

         e.preventDefault();

      });

   });

});

</script>
<style>
p

{

   font-size: 11px;

   font-family: Verdana;

   font-weight: bold;

   text-decoration: none;

   color: #666666;

}

th

{

   font-size: 11px;

   font-family: Verdana;

   font-weight: bold;

   text-decoration: none;

   background-color: #21211E;

   color: #FFFFFF;

   text-align: left;
   height:20px;
   padding-left:15px;
   padding-top:5px;
   padding-bottom:5px;
   padding-right:5px;

}
a
{

   text-decoration:none;
}
a:hover
{

   text-decoration: none;
}
body
{

   margin: 0;
   background-color: black;
   background-image: url(../images/welcome_bkgrnd.png);
   background-repeat: repeat-x;
   color: #000000;
}
</style>

</head>

<body>


<?php



   if (!$authorized)

   {



            echo "<center><div style='position:relative; top:20px; width:700px; padding:10px; height:300px; background:#333; box-shadow:1px 1px 2px #333; text-align:left;'><font color='#939393' face='calibri' size='3em'>Note: enter password and username</font>\n";

      echo "<center><div style='position:relative; width:300px; height:150px; top:50px;'><form method=\"post\" action=\"" .basename(__FILE__) . "\" >\n";

      echo "<font color='white' face='calibri'><span style='position:absolute; left:0px;'>$labelUserName&nbsp;&nbsp;</span><input type=\"text\" class='signupform_text' style='position:absolute; right:0px;' name=\"admin_username\" size=\"20\"><br><br>\n";

      echo "<span style='position:absolute; left:0px;'>$labelPassword&nbsp;&nbsp;</span><input type=\"password\" class='signupform_text' name=\"admin_password\" style='position:absolute; right:0px;' size=\"20\"></font><br><br>\n";

      echo "<input type=\"submit\" class='g-button g-button-submit' value=\"$labelLogin\" style='width:100px;position:absolute; right:0px;' name=\"submit\">\n";

      echo "<input type=\"hidden\" name=\"action\" value=\"login\" >\n";

      echo "</form>\n";

      echo "</div></center></div></center>\n";

   }

   else

   {

      echo "<div id=\"nav\" style='position:relative; top:0px; left:0px; height:30px;margin:0px; background:#333;'>\n";
      echo "<div style='position:relative; left:0px top:0px; padding10px; margin:0px;'>\n";

      echo "   <li><a href=\"" . basename(__FILE__) . "\">$labelHome</a></li>\n";

      echo "   <li><a href=\"" . basename(__FILE__) . "?action=new\">$labelNewPage</a></li>\n";

      if (sizeof($plugins) > 0)

      {

         echo "   <li><a>$labelPlugins</a>\n";

         echo "   <ul>\n";

         foreach($plugins as $pluginname=>$p)

         {

            if (isset($p['admin']['menu']))

            {

               foreach ($p['admin']['menu'] as $text=>$page)

               {

                  echo "      <li><a href=\"cmsadmin_plugin.php?_plugin=".$pluginname."&amp;_page=".$page."\">".$text."</a></li>\n";

               }

            }

         }

         echo "   </ul>\n";

         echo "   </li>\n";

      }

      echo "   <li style='position:absolute; right:0px; '><a href=\"" . basename(__FILE__) . "?action=logout\">$labelLogout from download manager</a></li>\n";

      echo "</div></div>\n";

      if (!empty($action))

      {

         if ($action == 'edit' || $action == 'new' || $action == 'copy')

         {

            $sql = "SELECT * FROM CMS_PAGES WHERE id = '".$id."'";

            $result = mysql_query($sql, $db);

            $name_value = '';

            $cname_value = '';

            $content_value = '';

            $visible_value = '';

            $url_value = '';

            $extra_data_value = '';

            $title_value = '';

            $description_value = '';

            $keywords_value = '';

            $created_by_value = '';

            if ($data = mysql_fetch_array($result))

            {

               $name_value = htmlspecialchars($data['name']);

               $cname_value = htmlspecialchars($data['cname']);

               $content_value = $data['content'];

               $visible_value = $data['visible'];

               $url_value = htmlspecialchars($data['url']);

               $extra_data_value = htmlspecialchars($data['extra_data']);

               $title_value = htmlspecialchars($data['title']);

               $description_value = htmlspecialchars($data['description']);

               $keywords_value = htmlspecialchars($data['keywords']);

               $created_by_value = htmlspecialchars($data['created_by']);

            }

            $extra_tabs = array();

            foreach($plugins as $pluginname=>$p)

            {

               if (isset($p['admin']['tab']))

               {

                  $extra_tabs[$p['admin']['tab']['name']] = $p['admin']['tab']['function'];

               }

            }



            echo "<form action=\"" . basename(__FILE__) . "\" method=\"post\">\n";

            echo "<div class=\"tab\" id=\"tab-general\">\n";

            if ($action == 'new' || $action == 'copy')

            {

               echo "<input type=\"hidden\" name=\"action\" value=\"create\">\n";

            }

            else

            {

               echo "<input type=\"hidden\" name=\"action\" value=\"update\">\n";

            }

           echo "<input type=\"hidden\" name=\"id\" value=\"". $id . "\">\n";

            echo "<table width=\"100%\" border=\"0\">\n";

            echo "<tr><td style=\"width:10%;white-space:nowrap;\">$labelName:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"name\" value=\"" . $name_value . "\"></td></tr>\n";

            echo "<tr><td style=\"width:10%;white-space:nowrap;\">$labelCompanyName:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"cname\" value=\"" . $cname_value . "\"></td></tr>\n";

            echo "<tr><td>$labelContent:</td>\n";

            echo "<td><textarea id=\"editor\" style=\"width:100%;height:500px\" name=\"content\">" . $content_value . "</textarea></td></tr>\n";

            echo "<tr><td>$labelURL:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"url\" value=\"" . $url_value . "\"></td></tr>\n";

            echo "<tr><td>$labelExtraData:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"extra_data\" value=\"" . $extra_data_value . "\"></td></tr>\n";

            echo "<tr><td>$labelTitle:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"title\" value=\"" . $title_value . "\"></td></tr>\n";

            echo "<tr><td>$labelDescription:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"description\" value=\"" . $description_value . "\"></td></tr>\n";

            echo "<tr><td>$labelKeywords:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"keywords\" value=\"" . $keywords_value . "\"></td></tr>\n";

            echo "<tr><td>$labelVisible:</td>\n";

            echo "<td><select name=\"visible\" size=\"1\"><option " . ($visible_value == "0" ? "selected " : "") . "value=\"0\">Hidden</option><option " . ($visible_value != "0" ? "selected " : "") . "value=\"1\">Visible</option></select></td></tr>\n";

            if ($username == 'admin')

            {

               echo "<tr><td>$labelOwner:</td><td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"created_by\" value=\"" . $created_by_value . "\"></td></tr>\n";

            }

            echo "</table>\n";

            echo "</div>\n";

            foreach($extra_tabs as $name=>$fn)

            {

               echo "<div class=\"tab\" id=\"tab-".preg_replace('/[^a-z0-9A-Z]/', '', $name)."\">\n";

               echo $fn();

               echo "</div>\n";

            }

            echo "<br><br><input style=\"position:absolute; right:10px;margin-bottom:50px;width:100px;\" type=\"submit\" class='g-button g-button-submit' name=\"save\" value=\"$labelSave\"><br><br>\n";

            echo "</form>\n";

         }

      }

      else

      {

         echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n";

         echo "<tr><th>$labelName</th>\n";

         echo "<th>$labelCreatedBy</th>\n";

         echo "<th>$labelLastUpdate</th>\n";

         echo "<th>$labelVisible</th>\n";

         echo "<th>$labelHomePage</th>\n";

         echo "<th>$labelViews</th>\n";

         echo "<th>$labelOrder</th>\n";

         echo "<th>$labelAction</th></tr>\n";



         $sql = "SELECT * FROM CMS_PAGES";

         if ($username != 'admin')

         {

            $sql = $sql . " WHERE created_by = '".$username."'";

         }

         $sql = $sql . " ORDER BY menu_index ASC";

         $result = mysql_query($sql, $db);

         $num_rows = mysql_num_rows($result);

         while ($data = mysql_fetch_array($result))

         {

            echo "<tr class='infoadmin'>\n";

            echo "<td><a href=\"store.php" . "?page=" . $data['seo_friendly_url'] . "\" id=\"" . $data['id'] . "\"  target='new'>" . $data['name'] . "</a></td>\n";

            echo "<td>" . $data['created_by'] . "</td>\n";

            echo "<td>" . $data['last_update_date'] . "</td>\n";

            echo "<td>" . ($data['visible'] == "0" ? $labelNo : $labelYes) . "</td>\n";

            echo "<td>";

            if ($data['home'] == "1")

               echo $labelYes;

            else

               echo "   <a href=\"" . basename(__FILE__) . "?action=home&id=" . $data['id'] . "\">$labelNo</a>";

            echo "</td>\n";

            echo "<td>" . $data['views'] . "</td>\n";

            echo "<td>";

            if ($data['menu_index'] <= 1)

            {

               echo "   <a href=\"" . basename(__FILE__) . "?action=movedown&id=" . $data['id'] . "\">$labelDown</a>";

            }

            elseif ($data['menu_index'] >= $num_rows)

            {

               echo "   <a href=\"" . basename(__FILE__) . "?action=moveup&id=" . $data['id'] . "\">$labelUp</a>";

            }

            else

            {

               echo "   <a href=\"" . basename(__FILE__) . "?action=moveup&id=" . $data['id'] . "\">$labelUp</a> &nbsp; ";

               echo "   <a href=\"" . basename(__FILE__) . "?action=movedown&id=" . $data['id'] . "\">$labelDown</a>";

            }

            echo "</td>\n";

            echo "<td>\n";

            echo "   <a href=\"" . basename(__FILE__) . "?action=edit&id=" . $data['id'] . "\">$labelEdit</a> | \n";

            echo "   <a href=\"" . basename(__FILE__) . "?action=copy&id=" . $data['id'] . "\">$labelCopy</a> | \n";

            echo "   <a href=\"" . basename(__FILE__) . "?action=delete&id=" . $data['id'] . "\">$labelDelete</a>\n";

            echo "</td>\n";

            echo "</tr>\n";

         }

         echo "</table>\n";

      }

   }



?>

</body>

</html>
Re: Problem on saving data to mysql with php script! 80 80

Waw.... nice php essay...

Have you tried Web Developer Tools for inpecting networks traffic(to check wheather the data was send or not) ?
It may help you..
From my understanding, you are trying to save $compny_name into database right ?
But in SQL INSERT function, I didn't see any $compny_name variable in the VALUES.

Re: Problem on saving data to mysql with php script! 80 80

nevermind solved it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.