points for predicting exact score

[terrorizer]

Hi,

My problem is that my script doesn't give users extra points for predicting the exact score. It does give users 3 points for predicting the winner.

I have got 3 tables;

$table1-->here is where i put the matchinfo. Important fields here are UITSLAG1 and UITSLAG2. It's where i put the final result of the match.(homegoals and awaygoals).

$table2-->here is where i put the userinfo. Important field here is PUNTEN. It's where i put the users total points.

$table3-->here is where i put the prediction info. Important fields here are TEAM1 and TEAM2. It's where the users predict the score for each team.

Could someone please help me?

Here's my script ( a part of it):

<?

$a="1";

$b="1";

$query99="SELECT * FROM $tabel1";

$result99=mysql_query($query99,$db);

while($wedstrijd=mysql_fetch_array($result99))

{

$winnaar[$a]="$wedstrijd[uitslag]";

$query1="SELECT * FROM $tabel3 WHERE winnaar='$winnaar[$a]'";

$result1=mysql_query($query1,$db);

while($us=mysql_fetch_array($result1))

{

$gebruiker[$b]="$us[gebruikersnaam]";

$query2="SELECT * FROM $tabel2 WHERE gebruikersnaam='$gebruiker[$b]'";

$result2=mysql_query($query2,$db);

while($rech=mysql_fetch_array($result2))

{

$totalpoints=("$rech[punten]" + "3");

$sql="UPDATE $tabel2 SET punten='$totalpoints' AND gebruikersnaam='$gebruiker[$b]'" or die ("Update mislukt!!");

$result=mysql_query($sql,$db);

$result = mysql_query("DELETE FROM $tabel3 WHERE winnaar='$winnaar[$a]' AND gebruikersnaam='$gebruiker[$b]'");

$a++;

$b++;

}

}

}

$result = mysql_query("DELETE FROM $tabel3");

echo "<b><center>Alle punten zijn geupdate";
?>

[leatherback]

Hi Terrorizer,

Building a voetbal database?

Hint -> unless you want to use the 'gebruikers' and 'winnaars' in other parts of the script again, you do not need to create an array (which you are doing by placing the [$a] and [$b] after winnaar and gebruiker). So you could remove that

-> To geta hold on what is happening, place a line:

echo $query99; after defining that query. Do so for each query. Then you can actually see what is being placed in the querys, so what the database is looking for.

-> this line:
$gebruiker[$b]="$us[gebruikersnaam]";
doesn't need the quotes.

I have some difficulty reading your script, but i think you could actually combine the first two scripts: If you have matchin colums (In your case table1.gebruikersnaam and table2.gebruikersnaam i think..) you can do a query on both tables at the same time like this:

Select * from table1, table2 where table1.gebruikersnaam = table2.gebruikersnaam and winnaar='$winnaar[$a]'"; 

That would remove one set of querying

-> The problem you are facing come from this line, I think:

$sql="UPDATE $tabel2 SET punten='$totalpoints' AND gebruikersnaam='$gebruiker[$b]' or die ("Update mislukt!!");

You want to use:

$sql="UPDATE $tabel2 SET punten='$totalpoints' where gebruikersnaam='$gebruiker[$b]

$result=mysql_query($sql,$db)or die ("Heb ik weer een tikfout gemaakt!??"); 

[terrorizer]

Hi,

yes, a prediction league to be exact.

first things first, thanks for your reaction leatherback!

$sql="UPDATE $tabel2 SET punten='$totalpoints' where gebruikersnaam='$gebruiker[$b]

$result=mysql_query($sql,$db)or die ("Heb ik weer een tikfout gemaakt!??");

My mistake! Stupid mistake!
Other hints are very helpfull indeed!

Thanks!

But still i cant get it to work.

I want my users to receive 2 extra points for predicting the exact outcome of a match.
So if the match between A and B ends in 2-1 and John Doe predicted this, he will receive 3 points for choosing the correct winner AND 2 extra points for predicting the exact score.

Could you help me with this?