msql probleem (phpmenno5)

Gynos schreef:

hey,

ik werk met phpmenno 5 en heb het ingesteld op mijn lay out

maar waar het nieuws moet komen staat er dit:

Warning: mysql_num_rows(): supplied

Warning: include(statistieken/online.php) [function.include]: failed to open stream: No such file or directory in /home/gynos/domains/habbobestand.nl/public_html/home/index.php on line 160

Warning: include(statistieken/online.php) [function.include]: failed to open stream: No such file or directory in /home/gynos/domains/habbobestand.nl/public_html/home/index.php on line 160

Warning: include() [function.include]: Failed opening statistieken/online.php for inclusion (include_path=.:/usr/local/lib/php) in /home/gynos/domains/habbobestand.nl/public_html/home/index.php on line 160

[COLOR= #0000BB]<?php

$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM nieuws_berichten ORDER BY datum DESC LIMIT 6"[/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]$sql[/COLOR][COLOR= #007700])) {[/COLOR]
    [COLOR= #0000BB]$row_member[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT gebruikersnaam FROM leden WHERE member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]member_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]));[/COLOR]
    [COLOR= #0000BB]$aantal_reacties[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT reactie_id FROM nieuws_reacties WHERE nieuws_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nieuws_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]));[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"
    <table>
        <tr>
            <td><strong><a href=?p=nieuws&nid="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nieuws_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></strong></td>
        </tr>
        <tr>
            <td><i>Gepost door : "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_member[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" op "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</i></td>
        </tr>
        <tr>
            <td>"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</td>
        </tr>
        <tr>
            <td style=text-align: right;><a href=?p=nieuws&nid="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nieuws_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">Lees meer</a> | <a href=?p=nieuws&nid="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nieuws_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantal_reacties[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" Reacties</a></td>
        </tr>
    </table><br><br>
    <hr align="left" />"[/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]0[/COLOR][COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Er zijn geen nieuws berichten gevonden.<br /><a href="javascript:history.go(-1)">Ga terug</a>"[/COLOR][COLOR= #007700];
}[/COLOR]

?>

Kyron schreef:

Wist je nu maar zelf wat je moest doen he
Je past mysql_num_rows verkeerd toe... Echo je $sql eens.