Ik heb hier 2 pagina's de ene voert de querys uit de andere haalt ze op uit de database, alleen willen ze niet werken
de missies.php maakt querys ( update de getallen in database)
en de update.php haalt de codes op voor een tekstje op mijn site:
missies.php
PHP
<?
if($badge['Trio'] == 1 && $badge['Basic'] == 1 && $badge['Insect'] == 1 && $badge['Bolt'] == 1 && $badge['Quake'] == 1 && $badge['Jet'] == 1 && $badge['Freeze'] == 1 && $badge['Legend'] == 1){
mysql_query("UPDATE `gebruikers_badges` SET `Unova`=`Unova`+'1' WHERE `user_id`='".$_SESSION['id']."'");
}
if($badge['Coal'] == 1 && $badge['Forest'] == 1 && $badge['Cobble'] == 1 && $badge['Fen'] == 1 && $badge['Relic'] == 1 && $badge['Mine'] == 1 && $badge['Icicle'] == 1 && $badge['Beacon'] == 1){
mysql_query("UPDATE `gebruikers_badges` SET `Sinnoh`=`Sinnoh`+'1' WHERE `user_id`='".$_SESSION['id']."'");
}
if($badge['Stone'] == 1 && $badge['Knuckle'] == 1 && $badge['Dynamo'] == 1 && $badge['Heat'] == 1 && $badge['Balance'] == 1 && $badge['Feather'] == 1 && $badge['Mind'] == 1 && $badge['Rain'] == 1){
mysql_query("UPDATE `gebruikers_badges` SET `Hoenn`=`Hoenn`+'1' WHERE `user_id`='".$_SESSION['id']."'");
}
if($badge['Zephyr'] == 1 && $badge['Hive'] == 1 && $badge['Plain'] == 1 && $badge['Fog'] == 1 && $badge['Storm'] == 1 && $badge['Mineral'] == 1 && $badge['Glacier'] == 1 && $badge['Rising'] == 1){
mysql_query("UPDATE `gebruikers_badges` SET `Jotho`=`Jotho`+'1' WHERE `user_id`='".$_SESSION['id']."'");
}
if($badge['Boulder'] == 1 && $badge['Cascade'] == 1 && $badge['Thunder'] == 1 && $badge['Rainbow'] == 1 && $badge['Marsh'] == 1 && $badge['Soul'] == 1 && $badge['Volcano'] == 1 && $badge['Earth'] == 1){
mysql_query("UPDATE `gebruikers_badges` SET `Kanto`=`kanto`+'1' WHERE `user_id`='".$_SESSION['id']."'");
}
?>update.php
PHP
<?
$badge = mysql_fetch_assoc(mysql_query("SELECT * FROM gebruikers_badges WHERE user_id ='".$_SESSION['id']."'"));
if($badge['Kanto'] >= 1)
{
echo '<img src="images/badges/Kanto.png" width="24" height="24" alt="Kanto Badge" title="Kanto Badge" /> Kanto Badge || Alle Kanto Badges gehaald!<br />';
}
if($badge['Jotho'] >= 1)
{
echo '<img src="images/badges/Jotho.png" width="24" height="24" alt="Jotho Badge" title="Jotho Badge" /> Jotho Badge || Alle Jotho Badges gehaald!<br />';
}
if($badge['Hoenn'] >= 1)
{
echo '<img src="images/badges/Hoenn.png" width="24" height="24" alt="Hoenn Badge" title="Hoenn Badge" /> Hoenn Badge || Alle Hoenn Badges gehaald!<br />';
}
if($badge['Sinnoh'] >= 1)
{
echo '<img src="images/badges/Sinnoh.png" width="24" height="24" alt="Sinnoh Badge" title="Sinnoh Badge" /> Sinnoh Badge || Alle Sinnoh Badges gehaald!<br />';
}
if($badge['Unova'] >= 1)
{
echo '<img src="images/badges/Unova.png" width="24" height="24" alt="Unova Badge" title="Unova Badge" /> Unova Badge || Alle Unova Badges gehaald!<br />';
}
if ($badge['Kanto'] == 0 && $badge['Jotho'] == 0 && $badge['Hoenn'] == 0 && $badge['Sinnoh'] == 0 && $badge['Unova'] == 0) echo '<div class=red>Je hebt nog geen Missie Badges</div>';
?>Het probleem is dat ik niet de fout zie waarom de cijfers in database niet worden geupdate