help please

[m00nz00mer]

hey i cant figure out why this doesnt work, i dont get any errors... anyone please?

 

basically what i want it to do is: if $checkRevQuery is true then display 'the end is near' else add the data to the db. It does add the data to the db when $checkRevQuery is false, however i cant get the message 'the end is near' to display? and ideas?

 

 

////////////////////////////////////

//Form Processing

if(isset($_POST['submitted'])) {

 

$formUser = trim($_POST['userName']);

$formDate = trim(date("Y-m-d"));

    $formComment = trim($_POST['comments']);

 

 

$checkRevQuery = "SELECT ID, ISBN FROM bookrev WHERE ISBN='".$_GET['bokID']."' AND ID LIKE '$formUser'";

$checkRevQueryResult = mysql_query($checkRevQuery);

 

if (!$checkRevQueryResult[0]) {

 

$formQueryCom = "INSERT INTO bookrev (ISBN, ID, revDate, revText) VALUES ('".$_GET['bokID']."', '$formUser', '$formDate', '$formComment')";

mysql_query($formQueryCom);

 

//Refresh the page

echo "<meta http-equiv='refresh' content='1'>";

 

} else {

 

echo "the end is near";

 

}

 

}

[conker87]

////////////////////////////////////
//Form Processing
if(isset($_POST['submitted'])) {

   $formUser      = trim($_POST['userName']);
   $formDate      = trim(date("Y-m-d"));
      $formComment    = trim($_POST['comments']);
   
   
   $checkRevQuery = "SELECT ID, ISBN FROM bookrev WHERE ISBN='".$_GET['bokID']."' AND ID LIKE '$formUser'";
   $checkRevQueryResult = mysql_query($checkRevQuery);
   
   if (mysql_num_rows($checkRevQueryResult) == 1) {   
      
      $formQueryCom = "INSERT INTO bookrev (ISBN, ID, revDate, revText) VALUES ('".$_GET['bokID']."', '$formUser', '$formDate', '$formComment')";
      mysql_query($formQueryCom);
   
      //Refresh the page
      echo "<meta http-equiv='refresh' content='1'>";
   
   } else {
   
      echo "the end is near";
   
   }
   
}

[m00nz00mer]

sorted thanks, apart from the logics are the wrong way round.