Update problem
| From: | Martin Kampherbeek | Date: | Sun, 12 Aug 2001 11:36:51 +0000 |
| Subject: | Update problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-62301@lists.php.net to get a copy of this message | ||
Hello,
I have created a predictionscompetition and the code below counts te total score of a match of a
person.
On the screen it workes, but in de database it goes wrong. Each person gets the total of the last
person. There must be something wrong with the update statement.
I hope someone can help me.
Belows are the tabels and the code. wedstrijden means matches and voorspelling1 means predictions.
Please help me.
Cheers,
Martin.
Tabel: users
id
username
naam
adres
postcode
woonplaats
telefoonnummer
geboortedatum
emailadres
password
Tabel: wedstrijden
id_wedstr
wedstrijd
uit_gr
uit_te
ru_gr
ru_te
minuut
toto
Tabel: voorspelling1
id_voorspelling
id_wedstr
id
naam
uit_gr
uit_te
ru_gr
ru_te
minuut
toto
totaal
Code:
<?php
mysql_connect("..............", "..............", "..............");
mysql_select_db (.............);
$query = "SELECT * FROM wedstrijden WHERE id_wedstr = 1";
$result = MYSQL_QUERY($query);
$uit_gr = mysql_result($result,$i,"uit_gr");
$uit_te = mysql_result($result,$i,"uit_te");
$ru_gr = mysql_result($result,$i,"ru_gr");
$ru_te = mysql_result($result,$i,"ru_te");
$minuut = mysql_result($result,$i,"minuut");
$toto = mysql_result($result,$i,"toto");
$uit_gr1 = $uit_gr;
$uit_te1 = $uit_te;
$ru_gr1 = $ru_gr;
$ru_te1 = $ru_te;
$minuut1 = $minuut;
$toto1 = $toto;
PRINT "$minuut1";
?>
<?php
mysql_connect("..................", "....................",
"...................");
mysql_select_db (....................);
$query = "SELECT * FROM voorspelling1";
$result = MYSQL_QUERY($query);
/* How many of these users are there? */
$number = MYSQL_NUMROWS($result);
/* Print these results to the screen in a nice format */
$i = 0;
IF ($number == 0) :
PRINT "<CENTER><P>Geen voorspellingen</CENTER>";
ELSEIF ($number > 0) :
PRINT "<P>Aantal voorspellingen: $number<BR><BR>";
PRINT "<b>Voorspellingen</b><BR><BR>";
WHILE ($i < $number):
$naam = mysql_result($result,$i,"naam");
$uit_gr = mysql_result($result,$i,"uit_gr");
$uit_te = mysql_result($result,$i,"uit_te");
$ru_gr = mysql_result($result,$i,"ru_gr");
$ru_te = mysql_result($result,$i,"ru_te");
$minuut = mysql_result($result,$i,"minuut");
$toto = mysql_result($result,$i,"toto");
IF ($uit_gr == $uit_gr1 AND $uit_te == $uit_te1):
$u1 = 5;
ELSE:
$u1 = 0;
ENDIF;
IF ($ru_gr == $ru_gr1 AND $ru_te == $ru_te1):
$r1 = 2;
ELSE:
$r1 = 0;
ENDIF;
IF ($u1 == 5 AND $r1 == 2):
$b1 = 2;
ELSE:
$b1 = 0;
ENDIF;
IF ($minuut == $minuut1):
$m1 = 4;
ELSE:
$m1 = 0;
ENDIF;
IF ($toto == $toto1 AND $u1 == 0):
$t1 = 2;
ELSE:
$t1 = 0;
ENDIF;
$t01 = $u1+$r1+$b1+$m1+$t1;
$sqlb = "UPDATE voorspelling1 SET totaal='$t01' WHERE id_voorspelling =
$id_voorspelling'";
$resultb = mysql_query($sqlb);
PRINT "$naam $uit_gr $uit_te $u1 $r1 $b1 $m1 $t1 $t01<BR>";
PRINT "$t1<BR>";
$i++;
ENDWHILE;
echo "Thank you! Information updated.\n";
ENDIF;
?>