Check Data

rahaiffi

whats wrong with this coding?
it still insert the data even the select query have found the data from database..
Help ME...

// *** Redirect if username exists
$MM_flag="SEND";
if (isset($_POST[$MM_flag])) {


  $id = $_POST['id'];
  $term = $_POST['term'];
  $year = $_POST['year'];
  if(is_array($_POST['code'])){
  foreach( $_POST['code'] as $code ){
  $LoginRS__query = "SELECT ID_STUD, TERM, YEAR, SUBJECT_CODE FROM result WHERE (ID_STUD='" . $id . "' AND TERM='" . $term . "') AND (YEAR='" . $YEAR . "' AND SUBJECT_code='" . $code . "') ";
   mysql_select_db($database_repi, $repi);
  $LoginRS=mysql_query($LoginRS__query, $repi) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);


  //if there is a row in the database, the username was found - can not add the requested username
  if($loginFoundUser){
   echo "<script language='Javascript'>
        alert(' ".$kod." is in the database!');
        </script>";
        break;
                         }

}
}
}

NogDog

Hard to say without seeing where you do the insert. Right now all you've shown us is that if there is at least one row returned by the query, then you output some JavaScript. That won't stop PHP code later in your script from running, if that's where the insert happens.

rahaiffi

This is the form action after the check coding at above..
i want to check if the mark of the sudent for subjects is in the database,then block the data to insert into database..
but, in the check coding at above still inset the data which the query found data in the database..
hope can help me..

include 'db_connect.php';
// build the form action

if($_POST['Send'] == "Send"){


$id = $_POST['id'];
$term = $_POST['term'];
$year = $_POST['year'];
if(is_array($_POST['mark']) and
   is_array($_POST['gred']) and
   is_array($_POST['code']) and
   is_array($_POST['subject']))
{
   $values = array();
   foreach($_POST['mark'] as $key => $mark)
   { 
   if(!empty($mark)){
      $gred = $_POST['gred'][$key];
      $code = $_POST['code'][$key];
      $subject = $_POST['subject'][$key];
      $values[] = "('$id','$term','$yaer','$mark','$gred','$code','$subject')";
                      }
   }
   $query = "INSERT INTO result ".
            "(id_stud, term, yaer, mark, gred, subject_code, name_subject) ".
            "VALUES " . implode(",", $values);
   $result = mysql_query($query) or die("Query failed: $query - " . mysql_error());
} 

					if ($sql) {
					include 'page.php';
	exit();
} else {
	echo mysql_error();
}		  

}

?>

rahaiffi

anyone can help me?