Aanbiedingen

Laatste 10 reacties

Gestart doorMarv3 reacties28 weergaven
Log in om mee te praten

4 berichten · pagina 1 van 1

Marv

Lid · Topicstarter

Berichten
3.092
Reputatie
1
Punten
0,21
Lid sinds
Laatst gezien
Hallo,

Ik was bezig met een scriptje om de laatste 10 topics weer te geven waar de user in gereageerd heeft.

En dan alleen de titel + datum.

De datum moet zijn van de laatste reactie in dat topic (niet van de user, ja kan wel als die als laatste heeft gereageerd)

Daar moeten ze ook op geordend worden.

Ik had dit:

[COLOR= #0000BB]<?php[/COLOR]
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SET lc_time_names = NL_nl"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$ReactieQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT t_id, DATE_FORMAT(datum, %d %M %Y, om %H:%i) AS datum FROM reacties WHERE poster = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]([/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]()) .[/COLOR] [COLOR= #DD0000]" ORDER BY datum DESC LIMIT 10"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]MYSQL error: [/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]    
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$ReactieFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$ReactieQuery[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$TopicQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM topics WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$ReactieFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]t_id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]MYSQL error: [/COLOR] [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]$ReactieQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Je hebt nog geen Reacties geplaatst.[/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]
    <table style="width: 100%">
    <tbody>
    <tr>
    [/COLOR][COLOR= #007700];[/COLOR]    
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$TopicFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$TopicQuery[/COLOR][COLOR= #007700])){[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]
    <td style="width: 72%;">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$TopicFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>
    <td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ReactieFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>[/COLOR][COLOR= #007700];
                }
            }[/COLOR]
        ?>


Wie me kan helpen krijgt 0.5 punt.

Groetjes smile
0
Marv

Lid · Topicstarter

Berichten
3.092
Reputatie
1
Punten
0,21
Lid sinds
Laatst gezien
wie voor 1 punt wink
0
Robertt

Lid

Berichten
1.579
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SET lc_time_names = NL_nl"[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$ReactieQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT t_id, DATE_FORMAT(datum, %d %M %Y, om %H:%i) AS datum FROM reacties WHERE poster = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]([/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]()) .[/COLOR] [COLOR= #DD0000]" ORDER BY datum DESC LIMIT 10"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]MYSQL error: [/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]    
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$ReactieFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$ReactieQuery[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$TopicQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM topics WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$ReactieFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]t_id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]MYSQL error: [/COLOR] [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]$ReactieQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Je hebt nog geen Reacties geplaatst.[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    ?>
    <table style="width: 100%">
    <tbody>
    <tr>
    [COLOR= #0000BB]<?php[/COLOR]    
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$TopicFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$TopicQuery[/COLOR][COLOR= #007700])){[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]
    <td style="width: 72%;">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$TopicFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>
    <td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ReactieFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>[/COLOR][COLOR= #007700];
                }
            }
            
    }[/COLOR]
        ?>
0
Antonn

Lid

Berichten
8.649
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Mensen wilden dit heus ook wel gratis doen hoor emohypocrite
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