Not showing even it must to.

[loonie34]

$result_username = mysql_fetch_row(mysql_query("SELECT username FROM users WHERE id=$id"));
$username = $result_username[0];

		if(isset($_SESSION['sms_nick_change']) && $_SESSION['sms_nick_change'] <= 1)
			{
				echo "<input type='text' name='username' value='$username'>";
			}
			else
			{
				echo "<b>$username</b>&nbsp;&nbsp;&nbsp;[<a class='change_name' href='sms.php'>Main&#299;t lietot&#257;jv&#257;rdu</a>]";
			}

This code is not working, it always says this - username [Change username] even if i have in database in column sms_nick_change <= 1.

[djjjozsi]

session_start();

is needed at the start of the php block.

[loonie34]

it already is.

[djjjozsi]

then print the $_SESSION['sms_nick_change'] value. or add a legal value to it, for example:

$_SESSION['sms_nick_change']="1";

And see the source code of the result:

<?php
$result_username = mysql_fetch_assoc(mysql_query("SELECT username FROM users WHERE id=$id"));
$username = $result_username["username"];

		if($_SESSION['sms_nick_change']== 1)
			{
				echo "<input type='text' name='username' value='$username'>";
			}
			else
			{
				echo "<b>$username</b>&nbsp;&nbsp;&nbsp;[<a class='change_name' href='sms.php'>Main&#299;t lietot&#257;jv&#257;rdu</a>]";
			}
?>

[loonie34]

i changed the database a litle bit, but anyway, code is not working, i tryed to use your code, the same, it just always shows me only one result.

$result_username = mysql_fetch_assoc(mysql_query("SELECT username FROM users WHERE id=$id"));
$username = $result_username["username"]; 
            if($_SESSION['sms_nick_change']== "-")
                {
                    echo "<b>$username</b>&nbsp;&nbsp;&nbsp;[<a class='change_name' href='#'>Main&#299;t lietot&#257;jv&#257;rdu</a>]";
                }
                else
                {
                    echo "<input type='text' name='username' value='$username'>";
                } 

in database now i have for sms_nick_change enum ('-','+').