[SOLVED] It says it worked but it didnt :S

[Dethman]

Ok here is the PHP

 

<?php
IF( ISSET($_POST['Submit']) ){
$NAME=$_POST['name'];
$COMPANY=$_POST['COMPNAME'];
$SEQUENCE=$_POST['sequence'];
$PAGE_INFO=$_POST['INFO'];
$pageID=$_GET['pageID'];


IF( EMPTY($NAME) ){
	$MESSAGE=("PAGE NAME WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");
}
    ELSE IF( EMPTY($COMPANY) ){
		$MESSAGE=("COMPANY NAME FOR PAGE WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");			
	}
	     ELSE IF( EMPTY($SEQUENCE) ){
			$MESSAGE=("SEQUENCE FOR PAGE WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");
		}
		      ELSE IF( EMPTY($PAGE_INFO) ){
				$MESSAGE=("PAGE INFO WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");
			}ELSE{
$SQL="UPDATE `page` SET `Name` ='$NAME', `Company` ='$COMPANY', `Sequence` ='$SEQUENCE', `pageInfo` ='$PAGE_INFO' WHERE `pageID` ='{$pageID}'";
$Result=mysql_query($SQL);

IF( $Result ){
 header("Location: ../admin.php?page=edit&strErr=Page Edited");
}
ELSE{
	header("LOCATION: admin.php?strErr=".mysql_error()."");
}

  }

}
?>

 

It does the if($Result){} and puts out the correct header but it didnt do put the query to the SQL DB It sayed it worked but it didnt please help!

[Andy-H]

It doesn't seem to connect to a database...

 

It's also poorly coded in caps for some strange reason and variables are un-protected. I know it's an admin script but even so.... Also it has no userlevel protection, I could make a form on my hosting and post data to it.

<?php
IF( ISSET($_POST['Submit']) ){
$NAME=$_POST['name'];
$COMPANY=$_POST['COMPNAME'];
$SEQUENCE=$_POST['sequence'];
$PAGE_INFO=$_POST['INFO'];
$pageID=$_GET['pageID'];


IF( EMPTY($NAME) ){
	$MESSAGE=("PAGE NAME WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");
}
    ELSE IF( EMPTY($COMPANY) ){
		$MESSAGE=("COMPANY NAME FOR PAGE WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");			
	}
	     ELSE IF( EMPTY($SEQUENCE) ){
			$MESSAGE=("SEQUENCE FOR PAGE WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");
		}
		      ELSE IF( EMPTY($PAGE_INFO) ){
				$MESSAGE=("PAGE INFO WAS LEFT BLANK PLEASE FILL IT IN BEFORE MOVING ON");
			}ELSE{
$SQL="UPDATE `page` SET `Name` ='$NAME', `Company` ='$COMPANY', `Sequence` ='$SEQUENCE', `pageInfo` ='$PAGE_INFO' WHERE `pageID` ='{$pageID}'";
$Result=mysql_query($SQL);

IF( $Result ){
 header("Location: ../admin.php?page=edit&strErr=Page Edited");
}
ELSE{
	header("LOCATION: admin.php?strErr=".mysql_error()."");
}

  }

}
?>