Custom chat not showing Usernames?

[asdfadrian]

Originally Posted by Lynne

This will not do anything:

$sql = @mysql_query("SELECT username FROM user WHERE userid=$userid");

                while ($row = @mysql_fetch_array($sql)){
                $name = $row['username'];
                $icon = $row['icon'];
                $color = $row['color'];
            }

You have a select statement that selects the username. That is all. There is no such thing as $row['color'] or $row['icon']. And, before you go think you can just add icon and color to the select statement, take a look at your user table - do you see those fields there? Nope. So, what are you trying to grab?

Well I cannot see the table but I know those table values do exist. We have another chat that uses the same calls and it has an icon and color table value. The old chat works, but its very buggy and Im trying to make a new chat from scratch.

I didnt make the first chat, my friend did. His chat uses those table values and the chat works, so I wouldnt see why this one would not. If you would like to see a demo of that chat you can do so Here. But you must register (and click on Remember me upon login) before proceeding. You will notice that the users and icons/ colors work accordingly.

Originally Posted by kh99

I think you want error_reporting(-1) to turn on all errors.

No, just the '@', which says to ignore errors from that call.

After removing the @ and changing the value to (-1) I received this error.

[22-May-2011 15:06:39] PHP Parse error:  syntax error, unexpected T_STRING in /home/xxxxx/public_html/community/wc3_nightelf/chat.php on line 7
[22-May-2011 15:06:39] PHP Parse error:  syntax error, unexpected T_STRING in /home/xxxxx/public_html/community/wc3_nightelf/chat.php on line 7