Webwereld

Nieuws php script

Gestart doorShahiem8 reacties62 weergaven
Log in om mee te praten

9 berichten · pagina 1 van 1

Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik zit alweer met een probleem.

Ik heb een nieuws script , als ik naar lees meer ga , en dan een id invul. Dan selecteer hij de eerste bericht in één van me categorieën.

Kan iemand me helpen?

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL] [COLOR= #DD0000]../inc/header.php[/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]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]act[/COLOR][COLOR= #007700]]) ==[/COLOR] [COLOR= #DD0000]leesmeer[/COLOR] [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #0000BB]$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM member_news WHERE nId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$sFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700]);[/COLOR]
    
    [COLOR= #0000BB]$nameQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM member_accounts WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nAuthor[/COLOR][COLOR= #007700]]);[/COLOR]
    [COLOR= #0000BB]$nameFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameQuery[/COLOR][COLOR= #007700]);[/COLOR]
    
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nVisible[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])
    {[/COLOR]
        [COLOR= #0000BB]$cQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT cId, cVisible, cAuth, cText, cDate FROM member_news_comment WHERE cNewsId ="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] . ([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) && ([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ==[/COLOR] TRUE [COLOR= #007700]?[/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000] AND cVisible = 1[/COLOR][COLOR= #007700])) .[/COLOR] [COLOR= #DD0000]" ORDER BY cId ASC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="midtop">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nTitle[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]) .[/COLOR] [COLOR= #DD0000] [/COLOR] [COLOR= #007700]. ([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) &&[/COLOR] is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ?[/COLOR][COLOR= #DD0000]<div style="float:right"><a href="admin_news?act=edit&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><img src="img/pencil.png" alt="Wijzigen" /></a>[/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nVisible[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000] <a href="admin_news?act=delete&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><img src="img/cross.png" alt="verwijderen" /></a></div>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000] <a href="admin_news?act=reopen&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><img src="img/newspaper_go.png" alt="Zet terug" /></a></div>[/COLOR][COLOR= #007700]) :[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</div><div class="midmid">[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div align="left" style="float: left;">Door <span style="color:[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000];font-weight: bold;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</span> | [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nDate[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</div>
        <div style="float: right;">([/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cQuery[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]) reacties</div>
        <div style="border-top: 1px dashed #787878; clear: both;"></div>
        
        [/COLOR][COLOR= #007700].[/COLOR]ParseUbb[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nText[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]
        
        </div><div class="midbot"></div>[/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]$cQuery[/COLOR][COLOR= #007700]))
        {[/COLOR]
           
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cQuery[/COLOR][COLOR= #007700]))
            {[/COLOR]
                [COLOR= #0000BB]$nameQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM member_accounts WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cAuth[/COLOR][COLOR= #007700]]);[/COLOR]
                [COLOR= #0000BB]$nameFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameQuery[/COLOR][COLOR= #007700]);[/COLOR]
                
                
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="midtop">Reactie van [/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]) .[/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]. ([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) &&  ([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #DD0000]<div style="float:right"><a href="/news_edit_comment?act=edit&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&amp;nId=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><img src="img/pencil.png" alt="Wijzigen" /></a>[/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cVisible[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000] <a href="/news_edit_comment?act=delete&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&nId=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><img src="img/cross.png" alt="Verwijderen" /></a></div>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000] <a href="news_edit_comment?act=reopen&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&amp;nId=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><img src="img/newspaper_go.png" alt="Zet terug" /></a></div>[/COLOR][COLOR= #007700]) :[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700])) .[/COLOR] [COLOR= #DD0000]</div><div class="midmid">[/COLOR][COLOR= #007700];[/COLOR]

    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div style="text-align: center; border-bottom: 1px dashed #000; margin-right: 5px;">
                Gepost op [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cDate[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]
            </div>
            <div style="width: 110px; float: left;"> <strong><a href="profiel?id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><span style="color:[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000];font-weight: bold;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</span></a></strong><br />[/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]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uAvatarUrl[/COLOR][COLOR= #007700]]))
            {[/COLOR]              
                [URL="http://www.php.net/echo"]echo[/URL] image_resize[COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uAvatarUrl[/COLOR][COLOR= #007700]]);
            }[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                <img src="img/muntjes.png" /> [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCoins[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]<br />
                <img src="img/ster.png" /> [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uRangN[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]
            </div>
            <div style="float: left; border-left: 1px dashed #000; width: 315px; padding: 5px; min-height: auto; height: auto;">[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] ParseUbb[COLOR= #007700]([/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cText[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]),[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</div></div>
            <div style="clear: both;"></div>[/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]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) &&[/COLOR] is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]))
        {[/COLOR]
        ?>
            <div class="midtop">Reageren</div>
<div class="midmid">
                [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] ubb[COLOR= #007700]([/COLOR][COLOR= #DD0000]textbox[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]text[/COLOR][COLOR= #007700]);[/COLOR] ?>
                <form name="textbox" action="news_reageer" method="POST">
                    <input type="hidden" name="NewsID" value="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?>" />
                    <textarea cols="40" rows="5" id="textbox" name="text"></textarea><br />
                    <input type="submit" name="submit" value="Reageer" />
                </form>
            </div>
                <div class="midbot"></div>

        [COLOR= #0000BB]<?php[/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="rederror"><br /><strong>Je moet ingelogd zijn om te reageren.</strong> <br /><a href="login">Log hier in</a> of <a href="registreer">maak een account aan.</a></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="rederror"><br /><strong>Dit nieuwsbericht is verwijderd</strong><br />Klik <a href="javascript:history.back(-1)">hier</a> om terug te gaan</div>[/COLOR][COLOR= #007700];    
    }       
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL]
[COLOR= #007700]{[/COLOR]

[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT naam FROM nieuws_categorie WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql[/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]$sql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
    [COLOR= #0000BB]$sql2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(1) AS aantal FROM member_news WHERE nVisible = 1 AND UCat = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql2[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];[/COLOR]
    
    [COLOR= #0000BB]$tot_pag[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantal[/COLOR] / [COLOR= #0000BB]5[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$p_n[/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/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]]) &&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]] < ([/COLOR][COLOR= #0000BB]$tot_pag[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])) {[/COLOR]
        [COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]p[/COLOR][COLOR= #007700]];
    }[/COLOR]
    
    [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]5[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR]
    
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$tot_pag[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++) {[/COLOR]
        [COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$p_n[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$d[/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="midtop">Paginanavigatie</div><div class="midmid"><a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$link[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/nieuws/categorie?id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]&p=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</a></div><div class="midbot"></div>[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]$tot_pag[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000] - [/COLOR][COLOR= #007700];
        }
    }[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<br /><br />[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$sql3[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM member_news WHERE UCat = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]" LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", 5"[/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]$sql3[/COLOR][COLOR= #007700]) >[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql3[/COLOR][COLOR= #007700])) {[/COLOR]
        
 [COLOR= #0000BB]$nameQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM member_accounts WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nAuthor[/COLOR][COLOR= #007700]]);[/COLOR]
        [COLOR= #0000BB]$nameFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameQuery[/COLOR][COLOR= #007700]);[/COLOR]
            
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                <div class="midtop"><a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$link[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/nieuws/nText?id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nTitle[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a></div><div class="midmid">
                <i>Door: <a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$link[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/profiel?id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nAuthor[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]&p=1">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a> op [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nDate[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</i><br />[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nText[/COLOR][COLOR= #007700]]) >[/COLOR] [COLOR= #0000BB]150[/COLOR][COLOR= #007700]) {[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/nl2br"]nl2br[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nText[/COLOR][COLOR= #007700]]),[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]150[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]...[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/nl2br"]nl2br[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nText[/COLOR][COLOR= #007700]]);
                }[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<br /><br /></div><div class="midbot"></div>[/COLOR][COLOR= #007700];
        }[/COLOR]
    [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$tot_pag[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++) {[/COLOR]
            [COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
            
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$p_n[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$d[/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="midtop">Paginanavigatie</div><div class="midmid"><a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$link[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/nieuws/categorie?id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]&p=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</a></div><div class="midbot"></div>[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]$tot_pag[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000] - [/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 nieuwsberichten in deze categorie.[/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]Deze categorie bestaat niet.[/COLOR][COLOR= #007700];
}
}[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL] [COLOR= #DD0000]../inc/footer.php[/COLOR][COLOR= #007700];[/COLOR]
?>
0
Kingunit

Lid

Berichten
10.409
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
sorry,,, wil je graag helpen maar ik snap je probleem niet..
0
Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik zal het opnieuw uitleggen, ik heb een nieuws script met 3 categorieën: Internationaal , Nationaal & Website.
Nu heb ik ook een lees meer functie. Maar als je bijvoorbeeld dit doet : http://url.nl/categorie.php?id=3&act=leesmeer?id=41 doet.
Dan selecteert hij een bericht uit een andere id.
0
Kingunit

Lid

Berichten
10.409
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
heb je je database inorde?
0
Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Jazeker
0
Daiman

Lid

Berichten
5.795
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
je gebruikt 2x id en dan werkt niet (corrigeer me als ik het verkeerd heb)
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
Ten eerst wat Daiman zegt: je gebruikt twee keer id=
En als tweede moet je in plaats van categorie.php?id=3&act=leesmeer?id=41 dan categorie.php?id=3&act=leesmeer&id=41 doen.
0
Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Dankjewel Rik smile
0
Habbofann

Lid

Berichten
493
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Getalletjessss en lettertjess pompom
//
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