Hyperlinks within a table - ''.$row['username'].''

Question

I have made a leaderboard table on my site, which returns the users in the MySQL database with the highest scores (score is a separate field). The fields in the leaderboard table are 'rank' 'username' and 'score'. I would like to link each username in the table to it's own profile page.

The profile pages are in the format /profile.php?user=$username. How would I go about adding an <a href> within the table (which is echoed in PHP):

echo '<tr>
    <td>' .$a. '</td>
    <td><a href="profile.php?user=' .$row['username']. '">' .$row['username']. '</a></td>
    <td>'.$row['count'].'</td>
</tr>';

I've tried the above, but it doesn't seem to work. It shows the usernames, but they don't have any hyperlinks.

What does the $a variable do? I have tried it in firefox. I have tried it and it works, please tell me what the $a does? — Etienne Marais, Jan 07 '11 at 08:04
try adding echo ''; before or after the statement. Then look if this it turns up in the output. This looks like you might be editing the wrong file. EDIT: use the magic constants for file and line I can not write the proper syntax in an comment :( — Oliver A., Jan 07 '11 at 08:17

score 2 · Accepted Answer · answered Jan 07 '11 at 08:11

<?php

$row = array(
    'username' => 'Username',
    'count' => 5
);

echo '<table><tr><td>'
    . $a . '</td><td><a href="profile.php?user='
    . $row['username'] . '">'
    . $row['username'] . '</a></td><td>'
    . $row['count'] . '</td></tr></table>';

?>

This works fine, I don't know what the problem is? I just do not know what $a does though

score 0 · Answer 2 · edited Jul 13 '13 at 13:06

0

Writing

echo '<tr> <td>'. $ a. '</ Td> <td> <a href="profile.php?user=' .$row['username'].'">'. $ Row ['username']. . '</ A> </ td> <td>' $ row ['count'] '</ td> </ tr>'.;

is incorrect because of:

</ A>

Correct version is:

echo '<tr> <td>'. $ a. '</ Td> <td> <a href="profile.php?user=' .$row['username'].'">'. $ Row ['username']. . '</ a> </ td> <td>' $ row ['count'] '</ td> </ tr>'.;

edited Jul 13 '13 at 13:06

zurfyx

31,043
20
111
145

answered Jul 13 '13 at 12:47

user2579195

1

score 0 · Answer 3 · answered Jan 07 '11 at 07:54

0

Looks correct to me. I would paste the (html) source-part it outputs, to get a hint what's really going on.

The retrieval part must be good, if you're seeing your usernames, so something strange is going on.

answered Jan 07 '11 at 07:54

Nanne

64,065
16
119
163

This is the table part of the page source: Rank Username Score 1ll20742ll20743kokok5544new2375taimur1346lllll07asdd08 – Taimur Jan 07 '11 at 07:58
That's just weird. I would add somethign in front of the tags and after them, just to make sure your code is actually being executed... – Nanne Jan 07 '11 at 08:02
And could you add some newlines to it while you're at it? :D – Nanne Jan 07 '11 at 08:06

Hyperlinks within a table - ''.$row['username'].''

3 Answers3

Linked