mysql_fetch_assoc() fails

[dominant]

The following code doesn't work

$user_id=$_SESSION['id'];
$result=mysql_query("SELECT username FROM users WHERE userid=$user_id");
$user_element=mysql_fetch_assoc($result);
echo $user_element[username];

When i use the mysql_fetch_array() it works ($user_element[0]😉

Why that happens?

[jernhenrik]

try:

echo $user_element["username"];

[dominant]

Thank you, it worked.

But the code i posted previously used to work in other systems, Where is the problem?

[jernhenrik]

array

assoc

whèn úsïng
mysql-fetch-assoc
yøú nèèd tø spècïfy thè åssøcïåtïøn thåt ïs thè nåmè ïn yøúr årråy, ås gïvèn ïn thè prèvïøús èxåmplè, èg: "úsèrnåmè", yøú cånnøt gèt thè dåtå by rèfèrèncïng tø å ïndèx èg: 0.

whèn úsïng
mysql-fetch-array
yøú cån úsè bøth. èg:
$userelement["username"] and $userelement[0]

hth

ps: rèåd thè månúål 😃

[dominant]

i can't understand your way of writing 🙁

[jernhenrik]

oh...

sorry about that 🙁 anyways check the links i provided, the manual has all the answers...

my strange writing is because of this:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10248827