Location: PHPKode > projects > Pointter PHP CMS > pointtercms_package/pointtercms_package/pointtercms/admin/functions/editcategorysubmit.php
<?php 

/***************************************************************************
 * Product Name			: Pointter PHP Content Management System
 * Version 			: V 1.2
 * Release Date			: 01/02/11
 * Copyright			: (C) 2011 PangramSoft / Murat Cevik
 * Program URL			: http://www.pointter.com
 * Company URL			: http://www.pangramsoft.com
 * Email Address                : hide@address.com
 
 ***************************************************************************/
 

/****************************************************************************

Pointter PHP Content Management System is licensed under Creative Commons Attribution Non-commercial No Derivatives 3.0 Unported (by-nc-nd) License.
To view a copy of this license, (a) visit http://creativecommons.org/licenses/by-nc-nd/3.0/ or (b) send a letter to Creative Commons, 171 2nd Street, 
Suite 300, San Francisco, California, 94105, USA.” 

You must not remove/modify/alter the copyright informations both visible and invisible forms in the source code and you must not remove/modify/alter 
the copyright informations in the footer part of the script including the Pointter image (png format file), hard link and title tag.

Please contact the copyright holder PangramSoft / Murat Cevik for a commercial license to remove the copyright information in the footer part of the script.


*****************************************************************************/

$cat=$_POST[cat];
$name=$_POST[name];


if ($name!="" AND $cat!="")
{

//Update Category Information Into Database
include '../../configset/conn.php';

$check=mysql_query("SELECT * FROM Category WHERE Name='$cat'");
$row=mysql_fetch_array($check);

if ($row[Code]==0)
 {
  mysql_query("UPDATE Products SET Category='$name',Subcode='$name' WHERE Category='$cat' AND Subcode='$cat'");
  mysql_query("UPDATE Products SET Subcode='$name' WHERE Category!='$cat' AND Subcode='$cat'");
 }
 else
 {
  mysql_query("UPDATE Products SET Category='$name' WHERE Category='$cat'");
 }

mysql_query("UPDATE Category SET Name='$name' WHERE Name='$cat'");
mysql_query("UPDATE Views SET Name='$name' WHERE Name='$cat'");
mysql_close($connect);
header("location:../editcategory.php");

}
else
header("location:../editcategory.php");

?>
Return current item: Pointter PHP CMS