I have a webform with the string variables $participant1, participant2, and $winner in php.When a form is posted it updates the columns participant and winner for two rows in my_table. The column type for winner is BOOLEAN.
Here is what my table currently looks like:
ID |Game |Participant | Winner
-------------------------------
1 1 John NULL
2 1 Frank NULL
The submitted variable $winner will be the name of either participant ('John' or 'Frank'). When it is submitted, I'd like for 1 to be set for which ever participant the string $winner matches. And 0 for the other participant.
i.e. if $participant1 =='John' and $winner=='John' Then the table should look like:
ID |Game |Participant | Winner
-------------------------------
1 1 John 1
2 1 Frank 0
I can't seem to figure this part out.
I tried:
$participant1= mysqli_escape_string( $con, $params['participant1']);
$participant2= mysqli_escape_string( $con, $params['participant2']);
$Winner= mysqli_escape_string( $con, $params['Winner']);
mysqli_query($con, "UPDATE my_table SET Winner = IF('$Winner'=='$participant1',1,0) WHERE Participant ='$participant1');
mysqli_query($con, "UPDATE my_table SET Winner = IF('$Winner'=='$participant2',1,0) WHERE Participant ='$participant2'");
Winner still shows NULL afterwards. Is there a primarily MySQL way to do this?
Aucun commentaire:
Enregistrer un commentaire