Webwereld

Forum

Gestart doorOne2xs4 reacties49 weergaven
Log in om mee te praten

5 berichten · pagina 1 van 1

One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Hoe zorg ik ervoor dat bij de onderstaande code de EERSTE row

krijgt en de rest

?

[COLOR= #0000BB]<?php[/COLOR]
    head[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Forum - index"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$hsql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_heads WHERE hRang <= "[/COLOR][COLOR= #007700].[/COLOR]rank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" ORDER BY hId ASC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hsql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<h2>Forum</h2>[/COLOR][COLOR= #007700];[/COLOR][URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Er zijn nog geen forums[/COLOR][COLOR= #007700];}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hsql[/COLOR][COLOR= #007700])){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<h2>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</h2>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<div class="forum_xjp">&nbsp;</div><div class="forum_info"><div class="forum_titel">Forum</div><div class="forum_topics">Topics</div><div class="forum_posts">Berichten</div><div class="forum_laatste">Laatste bericht</div></div><div class="forum_br"></div>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$csql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_cats WHERE hId = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND cRang <= "[/COLOR][COLOR= #007700].[/COLOR]rank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" ORDER BY cId ASC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/print"]print[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]<tr><td>[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]().[/COLOR][COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$csql[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$srow[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$csql[/COLOR][COLOR= #007700])){[/COLOR]
                    [COLOR= #0000BB]$post[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT SUM(tPosts) AS posts FROM forum_topics WHERE cId = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]error[/COLOR][COLOR= #007700]);[/COLOR]
                    [COLOR= #0000BB]$posts[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$post[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<div class="forum_xpj">&nbsp;</div><div class="forum_forumhead"><a href="[/COLOR][COLOR= #007700].[/COLOR]FULL_URL[COLOR= #007700].[/COLOR]ROOT_URL[COLOR= #007700].[/COLOR][COLOR= #DD0000]forum/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"><div class="forum_naam"><div class="forum_naam_">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div><div class="forum_beschrijving">[/COLOR][COLOR= #007700].[/COLOR]ubb[COLOR= #007700]([/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cBeschrijving[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]</div></div></a><div class="forum_topicss">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cTopics[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div><div class="forum_postss">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$posts[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]posts[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div><div class="forum_latste">Komt later</div>[/COLOR][COLOR= #007700];
                }
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Er zijn nog geen catergorie&eacute;n in dit forum[/COLOR][COLOR= #007700];
            }
        }
    }[/COLOR]
?>
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
    head[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Forum - index"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$hsql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_heads WHERE hRang <= "[/COLOR] [COLOR= #007700].[/COLOR] rank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]" ORDER BY hId ASC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hsql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<h2>Forum</h2>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Er zijn nog geen forums[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR]
        [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hsql[/COLOR][COLOR= #007700]))
        {[/COLOR]
            [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++;[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]<h2>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</h2>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]<h3>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</h3>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="forum_xjp">&nbsp;</div><div class="forum_info"><div class="forum_titel">Forum</div><div class="forum_topics">Topics</div><div class="forum_posts">Berichten</div><div class="forum_laatste">Laatste bericht</div></div><div class="forum_br"></div>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$csql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_cats WHERE hId = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND cRang <= "[/COLOR][COLOR= #007700].[/COLOR]rank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" ORDER BY cId ASC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/print"]print[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]<tr><td>[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]().[/COLOR][COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$csql[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
            {[/COLOR]
                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$srow[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$csql[/COLOR][COLOR= #007700]))
                {[/COLOR]
                    [COLOR= #0000BB]$post[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT SUM(tPosts) AS posts FROM forum_topics WHERE cId = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]error[/COLOR][COLOR= #007700]);[/COLOR]
                    [COLOR= #0000BB]$posts[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$post[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<div class="forum_xpj">&nbsp;</div><div class="forum_forumhead"><a href="[/COLOR][COLOR= #007700].[/COLOR]FULL_URL[COLOR= #007700].[/COLOR]ROOT_URL[COLOR= #007700].[/COLOR][COLOR= #DD0000]forum/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"><div class="forum_naam"><div class="forum_naam_">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div><div class="forum_beschrijving">[/COLOR][COLOR= #007700].[/COLOR]ubb[COLOR= #007700]([/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cBeschrijving[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]</div></div></a><div class="forum_topicss">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cTopics[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div><div class="forum_postss">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$posts[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]posts[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div><div class="forum_latste">Komt later</div>[/COLOR][COLOR= #007700];
                }
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Er zijn nog geen catergorie&eacute;n in dit forum[/COLOR][COLOR= #007700];
            }
        }
    }[/COLOR]
?>
0
One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Had het net zelf an gemaaktbiggrinhet lukte eerst efe niet maar het is (bijna) zelfde als jou scriptbiggrin
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Nice biggrin
0
One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
ik had dit:

[COLOR= #0000BB]<?php[/COLOR]
    head[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Forum - index"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$hsql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_heads WHERE hRang <= "[/COLOR][COLOR= #007700].[/COLOR]rank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" ORDER BY volgorde ASC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hsql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<h2>Forum</h2>[/COLOR][COLOR= #007700];[/COLOR][URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Er zijn nog geen forums[/COLOR][COLOR= #007700];}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
        [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hsql[/COLOR][COLOR= #007700])){[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700]){[/COLOR][COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700];}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR][COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700];}[/COLOR]
            [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++;[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<h[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$c[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</h[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$c[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]
            <div class="forum_xjp">&nbsp;</div>
            <div class="forum_info">
                <div class="forum_titel">Forum</div>
                <div class="forum_topics">Topics</div>
                <div class="forum_posts">Berichten</div>
                <div class="forum_laatste">&nbsp;</div>
            </div>
            <div style="clear:both;"></div>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$csql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM forum_cats WHERE hId = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND cRang <= "[/COLOR][COLOR= #007700].[/COLOR]rank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" ORDER BY cId ASC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/print"]print[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]<tr><td>[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]().[/COLOR][COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$csql[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$srow[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$csql[/COLOR][COLOR= #007700])){[/COLOR]
                    [COLOR= #0000BB]$post[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT SUM(tPosts) AS posts FROM forum_topics WHERE cId = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]error[/COLOR][COLOR= #007700]);[/COLOR]
                    [COLOR= #0000BB]$posts[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$post[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$posts[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]posts[/COLOR][COLOR= #007700]])){[/COLOR][COLOR= #0000BB]$posts[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]posts[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];}[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]
                    <div class="forum_xpj">&nbsp;</div>
                    <div class="forum_forumhead">
                        <a href="[/COLOR][COLOR= #007700].[/COLOR]FULL_URL[COLOR= #007700].[/COLOR]ROOT_URL[COLOR= #007700].[/COLOR][COLOR= #DD0000]forum/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">
                            <div class="forum_naam">
                                <div class="forum_naam_">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div>
                                <div class="forum_beschrijving">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ubb[/COLOR][COLOR= #007700]->[/COLOR]parse[COLOR= #007700]([/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cBeschrijving[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]</div>
                            </div>
                        </a>
                    </div>
                    <div class="forum_topicss">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$srow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cTopics[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div>
                    <div class="forum_postss">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$posts[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]posts[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</div>
                    <div class="forum_latste">&nbsp;</div>
                    <div style="clear:both;"></div>[/COLOR][COLOR= #007700];
                }
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]
                <div class="forum_xpj">&nbsp;</div>
                    <div class="forum_forumhead">
                        <div class="forum_naam">
                            <div class="forum_naam_">Geen categorie&eacute;n</div>
                            <div class="forum_beschrijving">Er zijn nog geen categorie&eacute;n in dit fora</div>
                        </div>
                    </div>
                    <div class="forum_topicss">0</div>
                    <div class="forum_postss">0</div>
                    <div class="forum_latste">&nbsp;</div>
                    <div style="clear:both;"></div>[/COLOR][COLOR= #007700];
            }
        }
    }[/COLOR]
?>
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren