Webwereld

MYSQL/PHP fout?

Gestart doorMarvinn25 reacties30 weergaven
Log in om mee te praten

26 berichten · pagina 1 van 2

Marvinn

Lid · Topicstarter

Berichten
2.609
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hoooi.

Kan iemand mij helpen ik heb deze code:

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
#badgewrapper {
    float:left;
    width:53px;
    height:70px;
}

#badgeimg {
    width:45px;
    height:45px;
    text-align:center;
}

#totalwrapper {
    padding-left:33px;
}

#badgecode {
    width:45px;
    height:25px;
    text-align:center;
}
html, body{

    font-family: verdana;
    font-size: 10;
}

</style>
              
            <div id="totalwrapper" >       
              [COLOR= #0000BB]<?php

$mysql_host[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"localhost"[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// dit is meestal localhost[/COLOR]
[COLOR= #0000BB]$mysql_user[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je username van mysql in[/COLOR]
[COLOR= #0000BB]$mysql_password[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je mysql wachtwoord in[/COLOR]
[COLOR= #0000BB]$mysql_database[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// hier vul je de naam van je database in[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]) ==[/COLOR] false [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]) ==[/COLOR] false[COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Oeps, kon geen verbinding maken met de database, Controleer de gegevens!"[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]);
}[/COLOR]

                                    [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges ORDER BY id DESC LIMIT 100"[/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]1[/COLOR][COLOR= #007700]) {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]""[/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]$sql_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges WHERE id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                            [COLOR= #0000BB]$row_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_badge[/COLOR][COLOR= #007700]);[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<div id="badgewrapper"><div id="badgeimg"><img border="0" src=http://images.habbo.com/c_images/album1584/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]".gif /></div><div id="badgecode">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</div></div> "[/COLOR][COLOR= #007700];
                        }
                    }[/COLOR]
                    ?></div>


Maar ik krijg deze fout:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/nickjexx/domains/habbotjes.be/public_html/badge/autobadge.php on line 49

Iemand een idee?
Wie het oplost krijgt 0.03 punten smile
0
Robertt

Lid

Berichten
1.579
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
#badgewrapper {
    float:left;
    width:53px;
    height:70px;
}

#badgeimg {
    width:45px;
    height:45px;
    text-align:center;
}

#totalwrapper {
    padding-left:33px;
}

#badgecode {
    width:45px;
    height:25px;
    text-align:center;
}
html, body{

    font-family: verdana;
    font-size: 10;
}

</style>
              
            <div id="totalwrapper" >       
              [COLOR= #0000BB]<?php

$mysql_host[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"localhost"[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// dit is meestal localhost[/COLOR]
[COLOR= #0000BB]$mysql_user[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je username van mysql in[/COLOR]
[COLOR= #0000BB]$mysql_password[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je mysql wachtwoord in[/COLOR]
[COLOR= #0000BB]$mysql_database[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// hier vul je de naam van je database in[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]) ==[/COLOR] false [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]) ==[/COLOR] false[COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Oeps, kon geen verbinding maken met de database, Controleer de gegevens!"[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]);
}[/COLOR]

                                    [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges ORDER BY id DESC LIMIT 100"[/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]1[/COLOR][COLOR= #007700]) {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]""[/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]$sql_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges WHERE id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                            [COLOR= #0000BB]$row_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_badge[/COLOR][COLOR= #007700]);[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<div id="badgewrapper"><div id="badgeimg"><img border="0" src=http://images.habbo.com/c_images/album1584/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]".gif /></div><div id="badgecode">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</div></div> "[/COLOR][COLOR= #007700];
                        }
                    }[/COLOR]
                    ?></div>
0
Marvinn

Lid · Topicstarter

Berichten
2.609
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/nickjexx/domains/habbotjes.be/public_html/badge/badge1.php on line 49
sadley
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
#badgewrapper {
    float:left;
    width:53px;
    height:70px;
}

#badgeimg {
    width:45px;
    height:45px;
    text-align:center;
}

#totalwrapper {
    padding-left:33px;
}

#badgecode {
    width:45px;
    height:25px;
    text-align:center;
}
html, body{

    font-family: verdana;
    font-size: 10;
}

</style>
              
            <div id="totalwrapper" >       
              [COLOR= #0000BB]<?php

$mysql_host[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"localhost"[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// dit is meestal localhost[/COLOR]
[COLOR= #0000BB]$mysql_user[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je username van mysql in[/COLOR]
[COLOR= #0000BB]$mysql_password[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je mysql wachtwoord in[/COLOR]
[COLOR= #0000BB]$mysql_database[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// hier vul je de naam van je database in[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]) ==[/COLOR] false [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]) ==[/COLOR] false[COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Oeps, kon geen verbinding maken met de database, Controleer de gegevens!"[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]);
}[/COLOR]

                                    [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges ORDER BY id DESC LIMIT 100"[/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/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]1[/COLOR][COLOR= #007700]) {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]""[/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]$sql_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges WHERE id="[/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]
                            [COLOR= #0000BB]$row_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_badge[/COLOR][COLOR= #007700]);[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<div id="badgewrapper"><div id="badgeimg"><img border="0" src=http://images.habbo.com/c_images/album1584/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]".gif /></div><div id="badgecode">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</div></div> "[/COLOR][COLOR= #007700];
                        }
                    }[/COLOR]
                    ?></div>
0
Robertt

Lid

Berichten
1.579
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
#badgewrapper {
    float:left;
    width:53px;
    height:70px;
}

#badgeimg {
    width:45px;
    height:45px;
    text-align:center;
}

#totalwrapper {
    padding-left:33px;
}

#badgecode {
    width:45px;
    height:25px;
    text-align:center;
}
html, body{

    font-family: verdana;
    font-size: 10;
}

</style>
              
            <div id="totalwrapper" >       
              [COLOR= #0000BB]<?php

$mysql_host[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"localhost"[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// dit is meestal localhost[/COLOR]
[COLOR= #0000BB]$mysql_user[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je username van mysql in[/COLOR]
[COLOR= #0000BB]$mysql_password[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// voer hier je mysql wachtwoord in[/COLOR]
[COLOR= #0000BB]$mysql_database[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"."[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// hier vul je de naam van je database in[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]) ==[/COLOR] false [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]) ==[/COLOR] false[COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Oeps, kon geen verbinding maken met de database, Controleer de gegevens!"[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_host[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_user[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$mysql_password[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql_database[/COLOR][COLOR= #007700]);
}[/COLOR]

                                    [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges ORDER BY id DESC LIMIT 100"[/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/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]1[/COLOR][COLOR= #007700]) {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]""[/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]$sql_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM habbo_badges WHERE id="[/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]
                            [COLOR= #0000BB]$row_badge[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_badge[/COLOR][COLOR= #007700]);[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<div id="badgewrapper"><div id="badgeimg"><img border="0" src=http://images.habbo.com/c_images/album1584/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]".gif /></div><div id="badgecode">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_badge[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</div></div> "[/COLOR][COLOR= #007700];
                        }
                    }[/COLOR]
                    ?></div>


Moet werken zo!
0
Marvinn

Lid · Topicstarter

Berichten
2.609
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
@Luukvdo Unknown column id in order clause

@Crazydog Unknown column id in order clause
0
Robertt

Lid

Berichten
1.579
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Dan kan hij id niet vinden wink
0
Marvinn

Lid · Topicstarter

Berichten
2.609
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Crazydog schreef:
Dan kan hij id niet vinden wink
En nu?
0
Robertt

Lid

Berichten
1.579
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Moet je die toevoegen h¨¦
$sql = mysql_query("SELECT * FROM habbo_badges ORDER BY id DESC LIMIT 100") or die(mysql_error());
Daar kan die id niet vinden wink
0
Marvinn

Lid · Topicstarter

Berichten
2.609
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
En hoe los je dat op?
0
Robertt

Lid

Berichten
1.579
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Dan staat id niet in de tabel habbo_badges
Doe dit is:

$sql = mysql_query("SELECT * FROM habbo_badges LIMIT 100") or die(mysql_error());
0
Marvinn

Lid · Topicstarter

Berichten
2.609
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Tabel: habbo_badges

Database naam/user: nickjexx_badge
Crazydog schreef:
Dan staat id niet in de tabel habbo_badges
Doe dit is:

$sql = mysql_query("SELECT * FROM habbo_badges LIMIT 100") or die(mysql_error());
Unknown column id in where clause
0
Marvinn

Lid · Topicstarter

Berichten
2.609
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Crazydog schreef:
Dan staat id niet in de tabel habbo_badges
Doe dit is:

$sql = mysql_query("SELECT * FROM habbo_badges LIMIT 100") or die(mysql_error());
Unknown column id in where clause

Sorry @ dubbelpost
0
Robertt

Lid

Berichten
1.579
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Heb je de gegevens wel weer ingevuld boven in ;-x/
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