Hi all :) I know some people here don't like me, well...sorry :(

Anyways, I have a code that displays the users online by selecting from a table like this:

$query = "SELECT DISTINCT * from battle_sessions";
$mysql_result = mysql_query($query);
while($row = mysql_fetch_array($mysql_result, MYSQL_ASSOC))
{
$link_challenge = append_sid("battle.$phpEx?mode=challenge&id=$row[user_id]");
$query2 = "SELECT * from phpbb_users where user_id = '$row[user_id]'";
$mysql_result2 = mysql_query($query2);

$row2 = mysql_fetch_array($mysql_result2, MYSQL_ASSOC);
print '<a href="' . $link_challenge . '">' . $row['username']. '</a><br>';

}

That works fine BUT now if and when it gets to their username I dont want it to make it a link, but it does...
Thanks :D

Uhm, shouldn't the username link refer to $row2['username'] and not $row['username']?

print "<a href=\"$link_challenge\">{$row2['username']}</a><br>";

try that.

Although wouldn't it be easier to do a sql table join?

Uhh, this code already works, reread my question....

bump

HINT!! "a href" creates a hyperlink;) Now, look at the script again.

People listen: The script works FINE 100% but I want to make an add on to it. When the user is on the page, it DOESNT display their username but everyone elses.....

Okay whats your point? He has a href.

Lol great....advice.....
Anyway what I mean is I want it to display theirs but not make it a link, i.e. they cant challenge themselves.

if ($row['username'] != <their username>) { // code without link }
else { // code with link }