HTML in PHP - displaying variables from MYSQL table

Question

I have a MYSQL table containing tournament data for players. Each player has stats like games_won, games_lost, etc. I am trying to display this information in a table.

My PHP code looks like this:

//Connecting to $db
//...

//Store table data into array
$result = mysqli_query($db, "SELECT * FROM ladder");

while($row = mysqli_fetch_array($result)) {
echo $row['id'] . " " . <a href=$row['link']$row['username']</a> . " " . $row['tourney_wins'] . " " . $row['game_wins'] . " " . $row['game_losses'] . " " . $row['last_played'];
echo "<br>";

I get an error (Unexpected "<") on

<a href=$row['link']$row['username']</a>

I am trying to display each username in the table as a hyperlink to their respective profile on another site. Can anyone give me a correction? Thanks!

echo $row['id'] . " " . < <= right there I'll bet. You're missing quotes. — Funk Forty Niner
– Funk Forty Niner, Commented Sep 5, 2014 at 15:58

Luke · Accepted Answer · 2014-09-05 16:12:07Z

1

This is how it should be quoted (assuming I interpreted how you wanted the link properly):

//Connecting to $db
//...

//Store table data into array
$result = mysqli_query($db, "SELECT * FROM ladder");

while($row = mysqli_fetch_array($result))
{
    echo( $row['id']." <a href='".$row['link']."'>".$row['username']."</a> ".$row['tourney_wins']." ".$row['game_wins']." ".$row['game_losses']." ".$row['last_played'] );
    echo("<br>");
}

edited Sep 5, 2014 at 16:12

answered Sep 5, 2014 at 16:04

Luke

4,0721 gold badge22 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shamal Sandeep · Accepted Answer · 2014-09-05 15:59:57Z

1

Change

<a href=$row['link']$row['username']</a>

to

"<a href=$row['link']$row['username']</a>"

answered Sep 5, 2014 at 15:59

Shamal Sandeep

5294 silver badges9 bronze badges

6 Comments

Shamal Sandeep Over a year ago

You must quote your HTML php cant interpret <a that's why It gave a syntax error.

zZShort_CircuitZz Over a year ago

Yep that was it, knew it was something with quotes but couldn't remember where they go. Thanks to you and Marc B

zZShort_CircuitZz Over a year ago

One more question...and this one might need a new topic because it's a different problem. But now I'm getting "Parse error: syntax error, unexpected " (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)" on the line we just changed.

Shamal Sandeep Over a year ago

Did u closed the HTML at </a>" with a quote ?

zZShort_CircuitZz Over a year ago

I did. ilovecode's submission fixed the Parse error

|

Marc B · Accepted Answer · 2014-09-05 15:59:59Z

1

You forgot to quote your html:

echo $row['id'] . " " . <a href=$row['link']$row['username']</a> . " " ...snip...
                       ^--here                                  ^--here

Since it's not quoted, PHP is interpreting it <a as concatenate less than undefined constant 'a', which makes no sense.

answered Sep 5, 2014 at 15:59

Marc B

362k44 gold badges433 silver badges508 bronze badges

1 Comment

David Jones Over a year ago

Also the a tag needs a closing > after the link

Collectives™ on Stack Overflow

HTML in PHP - displaying variables from MYSQL table

3 Answers 3

Comments

6 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

6 Comments

1 Comment

Related