Table help

Gestart doorJesper20 feb 201244 reacties112 weergaven

45 berichten · pagina 2 van 3

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

20 feb 2012, 15:54

#16

Haal je variabelen buiten quotes en gebruik error_reporting(E_ALL), en zet de display_errors op 1.
En verder zal je met deze query het aantal reacties nooit kunnen tellen, ik mis een WHERE voorwaarde.

Nog mooier is om dit met een JOIN op te halen of het aantal reacties los op te slaan.

Verder zie ik dat je while() nergens wordt geëindigd. En ik mis de accolades

Sebastiaanh

Lid

Berichten: 9.953
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 12 jun 2025

20 feb 2012, 15:56

#17

En je script is lek voor XSS

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

20 feb 2012, 16:14

#18

[COLOR= #0000BB]<?php
$quer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blogreactions"[/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]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$quer[/COLOR][COLOR= #007700])[/COLOR]


[COLOR= #0000BB]$sql_aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id FROM blogreactions WHERE id = "[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]" "[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_aantal_reactions[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blog ORDER BY id DESC LIMIT 10"[/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/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]))[/COLOR]



[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
<h2>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</h2><br />
<i>Door: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Op: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Categorie: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categorie[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700].[/COLOR][COLOR= #DD0000] Reacties </i><br />
<br />
[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]
<a href="?p=blogbekijken&id=[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]">Lees meer</a>[/COLOR][COLOR= #007700];[/COLOR] 






?>

Parse error: syntax error, unexpected T_VARIABLE in /home/u845065632/public_html/pages/home.php on line 6

Perry

Lid

Berichten: 3.112
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 6 okt 2018

20 feb 2012, 16:18

#19

Volgens mij krijg je niet alleen errors op regel 6 als ik het zo bekijk

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

20 feb 2012, 16:19

#20

Kun je alsjeblieft de oplossing geven? Het heeft nogal haast

Perry

Lid

Berichten: 3.112
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 6 okt 2018

20 feb 2012, 16:20

#21

Dat heeft het bij jou altijd. Doe eens rustig. (Komt eraan btw)

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

20 feb 2012, 16:21

#22

Oke, ik wacht

Marvinn

Lid

Berichten: 2.609
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 14 sep 2021

20 feb 2012, 16:22

#23

Probeer dit eens:

[COLOR= #0000BB]<?php
$quer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blogreactions"[/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]
[COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$quer[/COLOR][COLOR= #007700])[/COLOR]

[COLOR= #0000BB]$sql_aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id FROM blogreactions WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_aantal_reactions[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blog ORDER BY id DESC LIMIT 10"[/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/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]))[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
<h2>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</h2><br />
<i>Door: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Op: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Categorie: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categorie[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700].[/COLOR][COLOR= #DD0000] Reacties </i><br />
<br />
"[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]"
<a href="?p=blogbekijken&id=[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]">Lees meer</a>[/COLOR][COLOR= #007700];[/COLOR] 
?>

//Laatmaar

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

20 feb 2012, 16:23

#24

Indd, al geprobeert, werkt niet...

Perry

Lid

Berichten: 3.112
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 6 okt 2018

20 feb 2012, 16:24

#25

[COLOR= #0000BB]<?php
    $quer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blogreactions"[/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]
        [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$quer[/COLOR][COLOR= #007700])[/COLOR]
    [COLOR= #0000BB]$sql_aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id FROM blogreactions WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_aantal_reactions[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blog ORDER BY id DESC LIMIT 10"[/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/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<h2>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</h2>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<i>Door: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Op: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Categorie: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categorie[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] en [/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700].[/COLOR][COLOR= #DD0000] Reacties </i><br /><br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000][/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<a href="?p=blogbekijken&id=[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]">Lees meer</a>[/COLOR][COLOR= #007700];
        }[/COLOR]
?>

Ten 1e even wat netter gemaakt, ten 2e wat staat er ID in de tabel blogreactions?

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

20 feb 2012, 16:26

#26

Parse error: syntax error, unexpected T_VARIABLE in /home/u845065632/public_html/pages/home.php on line 4

Maartenl

Lid

Berichten: 5.897
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 27 sep 2025

20 feb 2012, 16:27

#27

[COLOR= #0000BB]<?php
    $quer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blogreactions"[/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]
        [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$quer[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$sql_aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id FROM blogreactions WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_aantal_reactions[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blog ORDER BY id DESC LIMIT 10"[/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/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<h2>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</h2>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<i>Door: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Op: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Categorie: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categorie[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] en [/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700].[/COLOR][COLOR= #DD0000] Reacties </i><br /><br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/nl2br"]nl2br[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]);[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<a href="?p=blogbekijken&id=[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]">Lees meer</a>[/COLOR][COLOR= #007700];
        }[/COLOR]
?>

Had je zelf kunnen vinden

Perry

Lid

Berichten: 3.112
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 6 okt 2018

20 feb 2012, 16:28

#28

Begin ik nou oud te worden, wat heb je veranderd

Marvinn

Lid

Berichten: 2.609
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 14 sep 2021

20 feb 2012, 16:29

#29

Gamedealer schreef:
Begin ik nou oud te worden, wat heb je veranderd?

Ik zie het ook niet meteen

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

20 feb 2012, 16:29

#30

[COLOR= #0000BB]<?php
    $quer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blogreactions"[/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]
        [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$quer[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$sql_aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id FROM blogreactions WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_aantal_reactions[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM blog ORDER BY id DESC LIMIT 10"[/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/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<h2>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</h2>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<i>Door: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Op: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] Categorie: [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categorie[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] en [/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$aantal_reactions[/COLOR] [COLOR= #007700].[/COLOR][COLOR= #DD0000] Reacties </i><br /><br />[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000][/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<a href="?p=blogbekijken&id=[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]">Lees meer</a>[/COLOR][COLOR= #007700];
        }[/COLOR]
?>

Hij showt overal: 1 terwijl er bij id: 3, 2 reacties zijn

Jouw reactie

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