Prijs

Gestart doorMitchels3 jul 20093 reacties38 weergaven

4 berichten · pagina 1 van 1

Lid · Topicstarter

Berichten: 2.396
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 12 jun 2025

3 jul 2009, 13:21

[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]../_include.php[/COLOR][COLOR= #007700]);[/COLOR]
design_boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Home[/COLOR][COLOR= #007700]);[/COLOR]
check_login[COLOR= #007700]();[/COLOR]
?>
<h2>Klikwedstrijd</h2>
Dit is de eerste klikwedstrijd op Money-Clicks! Deze loopt tot 15-08-09!<br>
<table width="100%">
<tr><td><strong>#</strong></td><td><strong>Naam</strong></td><td><strong>Punten</strong></td><td><strong>Prijs</strong></td></tr>
[COLOR= #0000BB]<?

$rank2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM `users` WHERE level = 1 ORDER BY klikwedstrijd DESC LIMIT 25"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top2[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top1[/COLOR][COLOR= #007700])){[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#FFD700" size="5">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]2[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#C0C0C0" size="4">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]3[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#B87333" size="3">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]klikwedstrijd[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$prijs[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700];
}[/COLOR]

?>
</table>
[COLOR= #0000BB]<?[/COLOR]
design_onder[COLOR= #007700]([/COLOR][COLOR= #DD0000]1[/COLOR][COLOR= #007700]);[/COLOR]
?>

In de tabel prijs staat het id en de prijs. Id 1 is voor de nummer 1 en Id 2 is voor de nummer 2 enz. Tot nummer 10.
Maar hoe zet ik dat in het script?

Sjoerd

Lid

Berichten: 13.482
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 20 okt 2025

3 jul 2009, 13:27

[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]../_include.php[/COLOR][COLOR= #007700]);[/COLOR]
design_boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Home[/COLOR][COLOR= #007700]);[/COLOR]
check_login[COLOR= #007700]();[/COLOR]
?>
<h2>Klikwedstrijd</h2>
Dit is de eerste klikwedstrijd op Money-Clicks! Deze loopt tot 15-08-09!<br>
<table width="100%">
<tr><td><strong>#</strong></td><td><strong>Naam</strong></td><td><strong>Punten</strong></td><td><strong>Prijs</strong></td></tr>
[COLOR= #0000BB]<?
$prijsql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id,prijs FROM prijs"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$prijsje[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$prijsql[/COLOR][COLOR= #007700])){[/COLOR]
[COLOR= #0000BB]$prijzenlijst[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$prijsje[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]] =[/COLOR] [COLOR= #0000BB]$prijsje[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]prijs[/COLOR][COLOR= #007700]];
}[/COLOR]
[COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM `users` WHERE level = 1 ORDER BY klikwedstrijd DESC LIMIT 25"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top2[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top1[/COLOR][COLOR= #007700])){[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#FFD700" size="5">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]2[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#C0C0C0" size="4">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$rank2[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]3[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<strong><font color="#B87333" size="3">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</font></strong>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$rank[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rank[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]klikwedstrijd[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td><td>[/COLOR][COLOR= #007700].([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$prijzenlijst[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #0000BB]$prijzenlijst[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700]] :[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$rank2[/COLOR][COLOR= #007700]++;
}[/COLOR]

?>
</table>
[COLOR= #0000BB]<?[/COLOR]
design_onder[COLOR= #007700]([/COLOR][COLOR= #DD0000]1[/COLOR][COLOR= #007700]);[/COLOR]
?>

Mitchels

Lid · Topicstarter