Compare two columns in one Table and use result in if condition?

Question

I'm trying to solve problem which will compare BEFORE INSERTING columns values partnerCode and partnerCodeOwner1 with username in the table below, If partnerCode and partnerCodeOwner1 values same with username should error message And insert shouldn't be completed! May be problem while comparing? Any syntax error?? PHP version 7.0

My attemp below but incorrect!

  $user_check_query = "SELECT * FROM refer";
  $result = mysqli_query($db, $user_check_query);
  $user = mysqli_fetch_assoc($result);


    if ($user['username'] === $user['partnerCodeOwner1']) {
      array_push($errors, "You can't add item to yourself");
    }

    if ($user['username'] === $user['partnerCode']) {
      array_push($errors, "You can't add item to yourself");
    }


if (count($errors) ==0) {
//Start inserting
}

Example in table

table: refer

      ID      randomfield    username      partnerCode    partnerCodeOwner1  
    +-------+ ------------+-------------+-----------------+-----------+
    |   1   | A45scdv     |  John       |  Not same       |    John   |
    +-------+-------------+-------------+-----------------+-----------+
    |   2   | das654d     | Alex        |  Alex           | Not same  |
    +-------+-------------+-------------+-----------------+-----------+

Are you using any code for DB insertion ? Your question is not complete at all. — Vincent Decaux, Jun 25 '19 at 13:36
what approach you have tried yet and what issue you facing? did you google it? — AZinkey, Jun 25 '19 at 13:38
You have 7 columns, 7 placeholders, but only 2 data types in your bind_param. You need to specify the types for every variable you're passing in — aynber, Jun 25 '19 at 13:39
Whenever a query does not work as it should, check for [mysqli errors](http://php.net/manual/en/mysqli.error.php) to find out the reason why. — aynber, Jun 25 '19 at 13:39
Stack Overflow is a Q&A service, not a programming academy. Your question is a duplicate. You aren't learning programming by writing some random code and posting it in Stack Overflow. Please find yourself a mysqli tutorial, learn how to perform basic queries and use that knowledge for this particular task. — Your Common Sense, Jun 25 '19 at 13:57

Compare two columns in one Table and use result in if condition?

0 Answers0