id to username

[peterisgb]

hello, I got this problem.

i've added in a little mod i made which shows the user id last win and last lost.

It displays the users ID but idealy i want it to show the players username instead,

how do i go about doing this,

Here is what i have to this might help put me in the right direction.

Last Win: ID <a href='viewuser.php?u={$r['lastwin']}'><font color='green'>{$r['lastwin']}</font><br /></a>

Last Lost: ID <a href='viewuser.php?u={$r['lastlost']}'><font color='red'>{$r['lastlost']}</font><br /></a>

[peterisgb]

i've updated this abit

 

$win= "{$r['lastwin']}";

$lost= "{$r['lastlost']}";

 

Last Win: ID <a href='viewuser.php?u={$r['lastwin']}'><font color='green'><b>$win</b></font><br /></a>

Last Lost: ID <a href='viewuser.php?u={$r['lastlost']}'><font color='red'><b>$lost</b></font><br /></a>

so anyhelp on displaying username?

[Danny696]

Just select it from the user table;

$win = @mysql_result($db->query("SELECT `username` FROM `users` WHERE (`userid` = " . $r['lastwin']. ");"),0,0);

and edit for the lost.

[peterisgb]

idea, this workd but now doing this affects the links,

What shall i do about that.

When placing mouse over the username it shows up the correct userid in the viewuser link but when you click this error comes up

QUERY ERROR: Unknown column 'N' in 'where clause'

Query was SELECT `username` FROM `users` WHERE (`userid` = N/A);

how would i go about solving this new problem.

[peterisgb]

this is still an issue can anyone help?

[peterisgb]

i'm not saying that this mod dont work, yet it doeswork but when a user clicks on the username it dont work

[peterisgb]

ok, well this didnt work, :(

[peterisgb]

well it didnt display anything

[Uridium]

Peter you will need too show us some lines of how users are called for and if its a fetch_array

[peterisgb]

well in the attack php, a sql update is sent to the users, lastwon and last lost

in profile it displays like this

Last Win: {$r['lastwon']} <br />

Last Lost: {$r['lastlost']} <br />

What is inserted into the database is the id of the user. which is working good.

[Uridium]

ok look at the SQL that grabs the select and if its a JOIN ask it to grab username aswell

[peterisgb]

i dont quite get what you mean there illusions, still an amature at the moment, still learning as of yet