Webwereld

PHP Foutje...

Gestart doorErik43 reacties241 weergaven
Log in om mee te praten

44 berichten · pagina 3 van 3

Erik

Lid · Topicstarter

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Huh?
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Zorg eens dat je op je scherm precies dezelfde query voor je krijgt als de query die door mysql_query() wordt uitgevoerd, en zorg dat je weet wat voor informatie $row bevat.
0
Erik

Lid · Topicstarter

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
K snap het niet.
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Wat is het script wat je nu hebt?
0
Erik

Lid · Topicstarter

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"top.php"[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #FF8000]//Men is ingelogd.[/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]id[/COLOR][COLOR= #007700]]))
                {[/COLOR]
[COLOR= #FF8000]//Boards ophalen[/COLOR]
[COLOR= #0000BB]$boardquery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"
                    SELECT *
                        FROM forumboards
                    WHERE
                        id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"
                        "[/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]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$boardquery[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                    <h1>
                        Topic plaatsen
                    </h1>
                    <a href="forum.php">Forum overzicht</a><br />[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #FF8000]//Men heeft op Plaats gedrukt.[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]verstuur[/COLOR][COLOR= #007700]]))
                    {[/COLOR]
                        [COLOR= #FF8000]//Variables klaarmaken[/COLOR]
                        [COLOR= #0000BB]$onderwerp[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$door[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doorid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doorrang[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rang[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doortopics[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]topics[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doorberichten[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] ubb[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #FF8000]//Is er iets ingevuld?[/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]$bericht[/COLOR][COLOR= #007700]) ||[/COLOR] [URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$onderwerp[/COLOR][COLOR= #007700]))
                        {[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                U heeft iets niet ingevuld.<br />
                <a href="#" onClick="history.back(-1)">Ga terug</a>[/COLOR][COLOR= #007700];
                        }[/COLOR]
                        [COLOR= #FF8000]//Alles oke, dus toevoegen[/COLOR]
                        [URL="http://www.php.net/else"]else[/URL]
                        [COLOR= #007700]{[/COLOR]
                            [COLOR= #FF8000]//Toevoegen[/COLOR]
                            [COLOR= #0000BB]$toevoeg[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"
                                                INSERT INTO
                                                    forumtopics
                                                (
                                                    door,
                                                    doorid,
                                                    doorrang,
                                                    doortopics,
                                                    doorberichten,
                                                    onderwerp,
                                                    bericht,
                                                    boardid
                                                )
                                                VALUES
                                                (
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$door[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doorid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doorrang[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doortopics[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doorberichten[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$onderwerp[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/print_r"]print_r[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"
                                                )
                                                "[/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/echo"]echo[/URL] [COLOR= #DD0000]
                Uw topic is succesvol toegevoegt.<br />
                <a href="forum.php">Forum overzicht</a>[/COLOR][COLOR= #007700];
                        }
                    }[/COLOR]
                    [COLOR= #FF8000]//Er is nog niet op Plaats geklikt.[/COLOR]
                    [URL="http://www.php.net/else"]else[/URL]
                    [COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                <form action="" method="post">
                    <div class="gebruikerinfo">[/COLOR][COLOR= #007700];[/COLOR]
                        [URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"ubb.php"[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                    </div>
                    <div class="bericht">
                        <input type="text" name="onderwerp" class="onderwerp" /><br />
                        <textarea name="bericht" cols="30" rows="10"></textarea><br />
                        <input type="submit" name="verstuur" value="Plaats" />
                    </div>
                </form>[/COLOR][COLOR= #007700];
                    }
                }[/COLOR]
                [COLOR= #FF8000]//Men is uitgelod[/COLOR]
                [URL="http://www.php.net/else"]else[/URL]
                [COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                Om deze pagina te mogen zien moet U ingelogd zijn.<br />
                <a href="inloggen.php">Inloggen</a>[/COLOR][COLOR= #007700];
                }[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"bottom.php"[/COLOR][COLOR= #007700]);[/COLOR]
?>
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Maak daar eens dit van:
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"top.php"[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #FF8000]//Men is ingelogd.[/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]id[/COLOR][COLOR= #007700]]))
                {[/COLOR]
[COLOR= #FF8000]//Boards ophalen[/COLOR]
[COLOR= #0000BB]$boardquery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"
                    SELECT *
                        FROM forumboards
                    WHERE
                        id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"
                        "[/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]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$boardquery[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                    <h1>
                        Topic plaatsen
                    </h1>
                    <a href="forum.php">Forum overzicht</a><br />[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #FF8000]//Men heeft op Plaats gedrukt.[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]verstuur[/COLOR][COLOR= #007700]]))
                    {[/COLOR]
                        [COLOR= #FF8000]//Variables klaarmaken[/COLOR]
                        [COLOR= #0000BB]$onderwerp[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$door[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doorid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doorrang[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rang[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doortopics[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]topics[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$doorberichten[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/addslashes"]addslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] ubb[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]);[/COLOR]
                        [COLOR= #FF8000]//Is er iets ingevuld?[/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]$bericht[/COLOR][COLOR= #007700]) ||[/COLOR] [URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$onderwerp[/COLOR][COLOR= #007700]))
                        {[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                U heeft iets niet ingevuld.<br />
                <a href="#" onClick="history.back(-1)">Ga terug</a>[/COLOR][COLOR= #007700];
                        }[/COLOR]
                        [COLOR= #FF8000]//Alles oke, dus toevoegen[/COLOR]
                        [URL="http://www.php.net/else"]else[/URL]
                        [COLOR= #007700]{[/COLOR]
                            [COLOR= #FF8000]//Toevoegen[/COLOR]
                            [COLOR= #0000BB]$toevoeg[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"
                                                INSERT INTO
                                                    forumtopics
                                                (
                                                    door,
                                                    doorid,
                                                    doorrang,
                                                    doortopics,
                                                    doorberichten,
                                                    onderwerp,
                                                    bericht,
                                                    boardid
                                                
                                                VALUES
                                                (
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$door[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doorid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doorrang[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doortopics[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$doorberichten[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$onderwerp[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",
                                                    "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"
                                                
                                                "[/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/echo"]echo[/URL] [COLOR= #DD0000]De query:<hr />FORUMCODE0<hr />$row:<br />FORUMCODE1[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                Uw topic is succesvol toegevoegt.<br />
                <a href="forum.php">Forum overzicht</a>[/COLOR][COLOR= #007700];
                        }
                    }[/COLOR]
                    [COLOR= #FF8000]//Er is nog niet op Plaats geklikt.[/COLOR]
                    [URL="http://www.php.net/else"]else[/URL]
                    [COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                <form action="" method="post">
                    <div class="gebruikerinfo">[/COLOR][COLOR= #007700];[/COLOR]
                        [URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"ubb.php"[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                    </div>
                    <div class="bericht">
                        <input type="text" name="onderwerp" class="onderwerp" /><br />
                        <textarea name="bericht" cols="30" rows="10"></textarea><br />
                        <input type="submit" name="verstuur" value="Plaats" />
                    </div>
                </form>[/COLOR][COLOR= #007700];
                    }
                }[/COLOR]
                [COLOR= #FF8000]//Men is uitgelod[/COLOR]
                [URL="http://www.php.net/else"]else[/URL]
                [COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                Om deze pagina te mogen zien moet U ingelogd zijn.<br />
                <a href="inloggen.php">Inloggen</a>[/COLOR][COLOR= #007700];
                }[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"bottom.php"[/COLOR][COLOR= #007700]);[/COLOR]
?>


en post de output / screenshot ervan hierzo.
0
Erik

Lid · Topicstarter

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near VALUES ( at line 13
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Ja oke omdat er wat haakjes missen door de smilies hierzo.

Achter boardid moet een ) en achter ".$row[id].".
0
Erik

Lid · Topicstarter

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Forum overzicht
De query:
--------------------------------------------------------------------------------

INSERT INTO
forumtopics
(
door,
doorid,
doorrang,
doortopics,
doorberichten,
onderwerp,
bericht,
boardid
)
VALUES
(
Erik,
1,
Administrator,
,
,
HH,
HHHHH ,

)

--------------------------------------------------------------------------------
$row:

Uw topic is succesvol toegevoegt.
Forum overzicht
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Dus is $row en dus ook $row[id] wel leeg..

Probeer eens te achterhale welke query dit wordt:
$boardquery = mysql_query("
SELECT *
FROM forumboards
WHERE
id = ".$_GET[id]."
" ) or die(mysql_error());
en voer die eens uit in PHPMyAdmin.
0
Erik

Lid · Topicstarter

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Fout
SQL-query:

$boardquery = mysql_query(

"
SELECT *
FROM forumboards
WHERE
id = ".$_GET[ id]. "
"
) OR die(
mysql_error(
)
)

MySQL retourneerde:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near $boardquery = mysql_query("
SELECT *
FROM forumboards
WHERE
id = ".$_GET[i at line 1
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Ja je moet achterhalen welke query het wordt he...

Dus die echoën zodat je weet wat de query wordt, dan in PHPMyAdmin invoeren om te kijken of hij uberhaupt wel werkt en wat hij teruggeeft.

Ik hoef toch niet alles voor te kauwen? emo.
0
Frankm

Lid

Berichten
137
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Voor die echo:
Probeer de heredoc syntax

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]<<<html
Hey tekst<br>
blaat
"" zonder error gaaaf he
html[/COLOR][COLOR= #007700];[/COLOR]
?>
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Nja daar ben ik niet zon fan van omdat je dan het overzicht een beetje kwijt raakt van wat nou HTML is en wat nou PHP is.
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