Unknow column in field list!

Gestart doorJoeri2 reacties30 weergaven

3 berichten · pagina 1 van 1

Joeri

Lid · Topicstarter

Berichten
5.737
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik krijg bij het script waar ik mee bezig ben dit :

Unknown column beoordeling in field list

[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/include"]include[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR] ?>



<div id="content_mid">

[COLOR= #0000BB]<?php[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"POST"[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]woot[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]beoordeling[/COLOR][COLOR= #007700]])) {[/COLOR]
            [COLOR= #0000BB]$fout[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #DD0000]U heeft geen website-naam niet ingevuld.[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]website-link[/COLOR][COLOR= #007700]])) {[/COLOR]
            [COLOR= #0000BB]$fout[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #DD0000]U heeft de website link niet ingevuld[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]opmerkingen[/COLOR][COLOR= #007700]])) {[/COLOR]
            [COLOR= #0000BB]$fout[/COLOR][COLOR= #007700][] =[/COLOR] [COLOR= #DD0000]U heeft geen omerkingen ingevuld[/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]$fout[/COLOR][COLOR= #007700])) {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div style="border: 1px dotted #962133; border-bottom: 2px solid #962133;background-color: #f75353;text-align:center;width:100%;">[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fout[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$val[/COLOR][COLOR= #007700]){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$val[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]<br />[/COLOR][COLOR= #007700];
            }[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];
        }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO beoordeling ( beoordeling, website, opmerkingen, ip ) VALUES ( "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]websitenaam[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]", "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]website-link[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]", "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]opmerkingen[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/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]<div style="border: 1px dotted #449D04; border-bottom: 2px solid #449D04; background-color: #96FF31;text-align:center;width:100%;">Uw aanmelding wordt verwerkt. Kijk regelmatig op de homepage voor meer informatie</div>[/COLOR][COLOR= #007700];
        }
            
    }[/COLOR]
    

?>

<form action="#" method="POST">
    <input type="hidden" name="woot" value="woot" /> 

   Websitenaam: <br />
    <input type="text" name="websitenaam" /> <br /><br />
    
    Website-Link: <br />
    <input type="text" name="website-link" /> <br /><br />
    
    Opmerkingen: <br />
    <textarea name="opmerkingen"></textarea> <br /><br />

    
    
       <input type="submit" name="submitsite" />
</form>                </div>


Terwijl ik in me database de tabel beoordeling heb neergeplant!

Weet iemand het?
0
Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
in de tabel beoordeling bestaat het veld beoordeling niet
0
Joeri

Lid · Topicstarter

Berichten
5.737
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Oh thnx nu snap ik het biggrin
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