Data not matching but code does not acknowledge this

[samanj]

Hi everyone,

My code is meant to give a certain response if the hospital number & PIN together do or do not match.

However, whatever I input, whether it is correct information or random numbers, I still get the output that the data has been submitted successfully.

Any thoughts?

 

<?php  

$connect = mysqli_connect($hostname, $username, $password, $databaseName);

    $query = "UPDATE card SET comments = '$comments' , seniorsent = '$seniorsent' WHERE hospitalnumber = '$hospitalnumber' and PIN = '$PIN'";
    @mysqli_query($connect, $query);

  $result = mysqli_query($connect, $query);

   if($result)
   {
       echo 'Data submitted successfully';
   }else{
       echo 'Please check that all details are correct';
   }

>

 

Thanks in advance,

samanj

[Barand]

Check the number of affected rows to see if any rows were updated. Not finding a record is not a query failure.

[samanj]

Ok thank you, I will check the number of rows. I think that will do the trick.