Foutje?

Hallo One2xs,
Ik ben bezig met mijn nieuwe project, maar loop ergens op vast. Op het forum laat hij bij mij de rang Schandaal! (verbannen) zien, maar op de ledenlijst staat er gewoon Keizer. Ik gebruik daarvoor dezelfde code.

function rang(){
      if($lFetch[rang] == 0){
        return Schandaal!;
      }elseif($lFetch[rang] == 1){
        return Burger;
      }elseif($lFetch[rang] == 2){
        return Senaat;
      }else{
        return Keizer;
      }
    }

$lQuery = mysql_query("SELECT * FROM leden WHERE naam = " . mysql_real_escape_string($t2Fetch[poster]) . " ") or die(mysql_error());
    $lFetch = mysql_fetch_assoc($lQuery);

Wie weet wat er fout is?

Mvg,
SebastiaanH

toevoeging op 18 februari 2012, 20:43:03:

echo <div id="foruminfo" /> <b>  . ucfirst(htmlentities($t2Fetch[poster])) .  </b> <br />  . rang() . </div><div id="forumpost" />  . ucfirst(htmlentities($t2Fetch[startpost])) .  </div> ;

mag ik de volledige code? Ik zou het trouwens anders aanpakken

toevoeging op 18 februari 2012, 20:47:12:

[COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]function[/COLOR] rang[COLOR= #007700]([/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700]){[/COLOR]
 [COLOR= #0000BB]$lolQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM leden WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$lolFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lolQuery[/COLOR][COLOR= #007700]);[/COLOR]

      [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lolFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rang[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Schandaal![/COLOR][COLOR= #007700];
      }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lolFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rang[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Burger[/COLOR][COLOR= #007700];
      }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lolFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rang[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Senaat[/COLOR][COLOR= #007700];
      }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Keizer[/COLOR][COLOR= #007700];
      }
    }[/COLOR]
?>

Werkt niet, hij blijft Schandaal! laten zien.

Er zaten wat foutjes in, het is nu opgelost. je roept hem zo aan:

[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] rang[COLOR= #007700]([/COLOR]useridwaarvanjerangwilt[COLOR= #007700]);[/COLOR] ?>

Ja dat snap ik.

Wheeerkt die??

Ja, nu wel. Bedankt
toevoeging op 18 februari 2012, 20:52:16:
Het topic mag open blijven voor als ik nog een andere fout heb.

Ik zou voor zoveel elseifjes een switch gebruiken.

[COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]function[/COLOR] rang[COLOR= #007700]([/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$lolQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT rang FROM leden WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$lolFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lolQuery[/COLOR][COLOR= #007700]);[/COLOR]

        [URL="http://www.php.net/switch"]switch[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lolFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rang[/COLOR][COLOR= #007700]]) {
            case[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]:[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Schandaal[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/break"]break[/URL][COLOR= #007700];        
            case[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]:[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Burger[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/break"]break[/URL][COLOR= #007700];            
            case[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]:[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Senaat[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/break"]break[/URL][COLOR= #007700];            
            default:[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]Keizer[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/break"]break[/URL][COLOR= #007700];
        }
    }[/COLOR]
?>

Zo heb ik het nu al, Jponsen. Toch bedankt.

gratz