OpenConnection(); $db->Query($sql); if($_REQUEST[parentCategoryList] != null) { $sql = "select name from category where id = $_REQUEST[parentCategoryList]"; $db->Query($sql); $db->GetNextRecord(); $catName = $db->GetField('name'); } else { $catName = ""; } $sql = "SELECT id FROM Category where name = '$_REQUEST[name]'"; $db->Query($sql); $db->GetNextRecord(); $id = $db->GetField('id'); $db->CloseConnection(); $msg = "Successfully updated category"; } else { //redirect header( 'Location: update.php' ) ; } ?> Update Category


Name:
Parent Category:

Modify Category