如果（$ tv =='0'）{echo'user'}，则根据值更改输出的数据

Question

I'm trying to change the output of a variable from 0 to display user or from 1 to display superuser,

<?php 
    $result = mysql_query("SELECT * FROM users ") or trigger_error(mysql_error());

    $tv = nl2br($row['type']);

    if ($tv == '0') {
        $tv = 'user';
    } elseif ($tv == '3') {
        $tv = 'superuser';                              
    } else {
        $tv = 'N/A';
    }

    while($row = mysql_fetch_array($result)){ 
        foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 
            echo "<tr>"; 
            echo "<td>" . nl2br( $row['name'] . "</td>";  
            echo "<td>" . nl2br( $row['email']) . "</td>"; 
            echo "<td>" . $tv . "</td>";  
            echo "</tr>";  
    } 
?>

i know I'm validating the data before i do the mysql_fetch_array and that should do it after, but i wasn't able to put the if statement in the echo

any help pls ?

Answer 1

You can't access $row before it is set, you can alter your echo line for $row['type'] like this:

if ($row['type'] == 0) { echo 'user'; } else if ($row['type'] == 1) { echo 'superuser';} else {echo 'NA'; }

---

<?php 
    $result = mysql_query("SELECT * FROM users ") or trigger_error(mysql_error());

    while($row = mysql_fetch_array($result)){ 
        foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 
            echo "<tr>"; 
            echo "<td>" . nl2br( $row['name'] . "</td>";  
            echo "<td>" . nl2br( $row['email']) . "</td>"; 
            echo "<td>"; if ($row['type'] == 0) { echo 'user'; } else if ($row['type'] == 1) { echo 'superuser';} else {echo 'NA'; } echo "</td>";  
            echo "</tr>";  
    } 

?>

---

I'm sure you have a reason for using nl2br, but I totally don't get it.

As @Zarathuztra has mentionend, please change to mysqli_ or PDO, mysql_ is not the way to go as it is deprecated