Kleine Vragen Topic #1

Alle getallen van die rij in een array stoppen, met max() kijken wat het hoogste getal is, dan je getallen doorlopen om ze in een tabel te stoppen, en ondertussen kijken of het huidige getal gelijk is aan het hoogste. Zo ja dan geef je m een kleurtje.

Red je het dan?

Lennard schreef:

Alle getallen van die rij in een array stoppen, met max() kijken wat het hoogste getal is, dan je getallen doorlopen om ze in een tabel te stoppen, en ondertussen kijken of het huidige getal gelijk is aan het hoogste. Zo ja dan geef je m een kleurtje.

Red je het dan?

Ja, ik heb nu een select voor de resultaten tabel, en een select die alle MAX ophaalt. Bij het uitvoeren in de while kijkt hij of ze gelijk zijn, zoja geeft hij ze een extra kleurtje.

Dat moet je niet met 2 queries doen joh, dat is niet nodig. Je kan met max() in PHP al kijken of iets het hoogste getal is, dan ontlast je je database.

Lennard schreef:

Dat moet je niet met 2 queries doen joh, dat is niet nodig. Je kan met max() in PHP al kijken of iets het hoogste getal is, dan ontlast je je database.

Oké, dan zal ik er nog eens opnieuw naar kijken

Nice als t niet lukt dan post je t hier maar weer.

Hoi,

Ik ben nu bezig met PHP en nu heb ik via een tutorial een optelsom script gemaakt.
Alleen nu gaf die bij mij alleen het antwoord.

Nu heb ik zelf al de berekening ervoor gezet maar nu wil ik graag ook dat het antwoord = 20 komt.
Hoe doe ik dit?

LIVE voorbeeld: http://ravio.eu

SCRIPT.

[COLOR= #0000BB]<?php
       $cijfer1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]16[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$antwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" + "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$antwoord[/COLOR][COLOR= #007700];[/COLOR]
       ?>

Alvast bedankt!

Raalphh schreef:

Hoi,

Ik ben nu bezig met PHP en nu heb ik via een tutorial een optelsom script gemaakt.
Alleen nu gaf die bij mij alleen het antwoord.

Nu heb ik zelf al de berekening ervoor gezet maar nu wil ik graag ook dat het antwoord = 20 komt.
Hoe doe ik dit?

LIVE voorbeeld: http://ravio.eu

SCRIPT.

[COLOR= #0000BB]<?php
       $cijfer1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]16[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$antwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" + "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$antwoord[/COLOR][COLOR= #007700];[/COLOR]
       ?>

Alvast bedankt!

[COLOR= #0000BB]<?php
       $cijfer1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]16[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$antwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" + "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] = [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$antwoord[/COLOR][COLOR= #007700];[/COLOR]
       ?>

zo?

Bartv schreef:

Eerdere citaten tonen

Raalphh schreef:

Hoi,

Ik ben nu bezig met PHP en nu heb ik via een tutorial een optelsom script gemaakt.
Alleen nu gaf die bij mij alleen het antwoord.

Nu heb ik zelf al de berekening ervoor gezet maar nu wil ik graag ook dat het antwoord = 20 komt.
Hoe doe ik dit?

LIVE voorbeeld: http://ravio.eu

SCRIPT.

[COLOR= #0000BB]<?php
       $cijfer1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]16[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$antwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" + "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$antwoord[/COLOR][COLOR= #007700];[/COLOR]
       ?>

Alvast bedankt!

[COLOR= #0000BB]<?php
       $cijfer1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]16[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700];[/COLOR]
       [COLOR= #0000BB]$antwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
       [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" + "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] = [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$antwoord[/COLOR][COLOR= #007700];[/COLOR]
       ?>

zo?

Ja bedankt maar als je dubbele " doet dan pakt die = niet, want dat had ik ook al geprobeerd.

Nu wil ik graag alle cijfers doen maar om steeds een nieuwe string en echo aan te maken lijkt me een beetje veel.
Kan dit ook met behulp van een database en dat ik dan de gegevens eruit opvraag? Alleen hoe doe ik dit?

Hoe had je het dan?
Want dit werkt gewoon:

[COLOR= #0000BB]<?php
$cijfer1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]16[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$antwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" + "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$antwoord[/COLOR][COLOR= #007700];[/COLOR]
?>

Lennard schreef:

Hoe had je het dan?
Want dit werkt gewoon:

[COLOR= #0000BB]<?php
$cijfer1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]16[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$antwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$cijfer1[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" + "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cijfer2[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$antwoord[/COLOR][COLOR= #007700];[/COLOR]
?>

Hmm raar dan zal ik wel iets anders fout hebben gedaan.
Maar wat raden jullie aan om te gebruiken? " of ?

En zou u me vorige vraag nog eens willen lezen. Alvast bedankt!

Mikek schreef:

Eerdere citaten tonen

Milan schreef:

Kijk even wat ik veranderd heb en vertel mij eens wat je fout deed

$row[timestamp] = date(G:i:s j-n-Y, strtotime($row[timestamp]));

echo date(G:i:s j-n-Y, $row[timestamp]);

Is de eerste van overbodig, ik zette de timestamp dus nog een x om,

Stiekem wist ik dat al..

@ralph je moet gebruiken, " kan ook maar is zwaarder om te parsen voor php omdat je met " dit kan doen: "$var" en dan wordt var weergeven, dit is wel niet de juiste manier. $var zal het niet doen, probeer maar eens uit

Milan schreef:

@ralph je moet gebruiken, " kan ook maar is zwaarder om te parsen voor php omdat je met " dit kan doen: "$var" en dan wordt var weergeven, dit is wel niet de juiste manier. $var zal het niet doen, probeer maar eens uit

Oke bedankt voor de informatie!

Kan iemand mij helpen met het volgende:
hij geeft op een van mijn paginas dit aan:
Notice: Undefined variable: mesaj in /home/timvz/domains/kelta.nl/public_html/addurl.php on line 89

Dit is addurl.php:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]header.php[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][COLOR= #0000BB]$is_online[/COLOR][COLOR= #007700]){[/COLOR]
    redirect[COLOR= #007700]([/COLOR][COLOR= #DD0000]index.php[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/exit"]exit[/URL][COLOR= #007700];
}[/COLOR]
[COLOR= #0000BB]$error[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]])){[/COLOR]
    [COLOR= #0000BB]$url[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]EscapeString[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]]);[/COLOR]
    [COLOR= #0000BB]$title[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]EscapeString[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]title[/COLOR][COLOR= #007700]]);[/COLOR]
    [COLOR= #0000BB]$cpc[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]EscapeString[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cpc[/COLOR][COLOR= #007700]]);[/COLOR]
    [COLOR= #0000BB]$coins[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]EscapeString[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]coins[/COLOR][COLOR= #007700]]);[/COLOR]
    [COLOR= #0000BB]$maxcpc[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]premium[/COLOR][COLOR= #007700]] >[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #0000BB]10[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]5[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$title[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">Add your page title!</div></div>[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/preg_match"]preg_match[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"%^(https?://)([a-z0-9-].?)+(:[0-9]+)?(/.*)?$%i"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$url[/COLOR][COLOR= #007700])){[/COLOR]
        [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">Please enter an valid URL</div></div>[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]coins[/COLOR][COLOR= #007700]] >[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]coins[/COLOR][COLOR= #007700]]){[/COLOR]
        [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">You dont have enough coins!</div></div>[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]coins[/COLOR][COLOR= #007700]]) ||[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]coins[/COLOR][COLOR= #007700]] <= -[/COLOR][COLOR= #0000BB]1[/COLOR] [COLOR= #007700]||[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]coins[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">You have to add at least 1 coin!</div></div>[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cpc[/COLOR][COLOR= #007700]] <[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cpc[/COLOR][COLOR= #007700]] >[/COLOR] [COLOR= #0000BB]$maxcpc[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">CPC incorrect!</div></div>[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"google"[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id FROM `sites` WHERE `site`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$url[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]GetNumRows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">Website already added!</div></div>[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO `sites` (user, site, title, points, cpc) VALUES("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]login[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$url[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$title[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cpc[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]") "[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `users` SET `coins`=`coins`-"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE `id`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="success">Website added successfully!</div></div>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
        }
        
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"youtube"[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$x[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/explode"]explode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]=[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$url[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/preg_match"]preg_match[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"/b&b/i"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$x[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]])){[/COLOR]
            [COLOR= #0000BB]$y[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/explode"]explode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]&[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$x[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]]);[/COLOR] 
            [COLOR= #0000BB]$z[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$y[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$z[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$x[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]];
        }[/COLOR]
            [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `youtube` WHERE `youtube`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$z[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND `user`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]GetNumRows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">Video already added!</div></div>[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$z[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]){[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">Please enter a valid Youtube link!</div></div>[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO `youtube` (user, youtube, title, points, cpc) VALUES("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$z[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$title[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cpc[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]") "[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `users` SET `coins`=`coins`-"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE `id`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="success">Video added successfully!</div></div>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
        }
        
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"surf"[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `surf` WHERE `site`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$url[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND `user`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]GetNumRows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">Website already added!</div></div>[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO `surf` (user, site, title, points, cpc, confirm) VALUES("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$url[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$title[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cpc[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", 1) "[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `users` SET `coins`=`coins`-"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE `id`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]FetchArray[COLOR= #007700]([/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `id` FROM `surf` WHERE `site`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$url[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND `user`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]));[/COLOR]
            redirect[COLOR= #007700]([/COLOR][COLOR= #DD0000]c_surf.php?id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$sid[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
        }
        
    }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"facebook"[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `facebook` WHERE `facebook`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$url[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]GetNumRows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$num[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="error">Page already added!</div></div>[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO `facebook` (user, facebook, title, points, cpc) VALUES("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$url[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$title[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cpc[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]") "[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$db[/COLOR][COLOR= #007700]->[/COLOR]Query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `users` SET `coins`=`coins`-"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$coins[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE `id`="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<div class="msg"><div class="success">Page added successfully!</div></div>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$error[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
        }
    }
}[/COLOR]?>
<div class="block medium right">
            <div class="top">        
                    <h1>Add Site</h1> 
            </div>
            <div class="content">[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$mesaj[/COLOR][COLOR= #007700];[/COLOR] ?>
<form method="post">
<fieldset>
    <p>
        <label>Type</label> <br/>
        <select class="styled" name="type">
            <option value="facebook">Facebook</option>
            <option value="google">Google +1</option>
            <option value="surf">Traffic exchange</option>
            <option value="youtube">Youtube Video</option>
        </select>
    </p>
    <p>
        <label>Link</label> <small class="above">Add your url here</small><br/>
        <input class="text big" type="text" value="http://" name="url" />
    </p>
    <p>
        <label>Title</label> <small class="above">Add your site title here</small><br/>
        <input class="text big" type="text" value="" name="title" maxlength="30" />
    </p>
    <p>
        <label>Coins</label> <small class="above">Add some coins</small><br/>
        <input class="text big" type="text" value="5" name="coins" maxlength="5" />
    </p>
    <p>
        <label>CPC*</label> <br/>
        <select class="styled" name="cpc">
            <option value="1">1 Coin</option>
            <option value="2">2 Coins</option>
            <option value="3">3 Coins</option>
            <option value="4">4 Coins</option>
            <option value="5">5 Coins</option><?if($data[premium] > 0){?>
            <option value="6">6 Coins</option>
            <option value="7">7 Coins</option>
            <option value="8">8 Coins</option>
            <option value="9">9 Coins</option>
            <option value="10">10 Coins</option><?}?>
        </select>
    </p>
    <p><small><b>* Coins per Click.</b></small></p>    
    <p>
        <input type="submit" class="button gray small" value="Add site" name="submit" />
    </p>
</fieldset>
</form>
                </div>
            </div>    
<script>
document.getElementById("currentpoints").innerHTML="<?=($error == 0 ? ($data[coins]-$_POST[coins]) : $data[coins])?>";
</script>            
<?include(footer.php);?>

@hierboven: Vervang

[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$mesaj[/COLOR][COLOR= #007700];[/COLOR] ?>

Door

[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #0000BB]$mesaj[/COLOR] [COLOR= #007700]:[/COLOR] null[COLOR= #007700];[/COLOR] ?>

zat zou moeten werken. Komt erop neer dat die var pas wordt gemaakt na het uitvoeren van de submit.