html/php SQL populated nav bar not

Question

this is my php code for populating my nav bar through an SQL query. I'm getting the following error:

Parse error: syntax error, unexpected 'index' (T_STRING), expecting ',' or ';' in /home/hj016/public_html/SKSSTW/index1.php on line 102

<?php
$sqlCommand = "SELECT id, linklabel FROM pages "; 
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error()); 
while($row = mysqli_fetch_array($query )) 
{    
echo "<li><a href="index.php?pid=".$row['linklabel'].>".$row['linklabel']."</a></li>";     
}
?>

Any help is appreciated.

artahian · Accepted Answer · 2013-03-19 17:14:19Z

3

Change

echo "<li><a href="index.php?pid=".$row['linklabel'].>".$row['linklabel']."</a></li>";

to

echo '<li><a href="index.php?pid='.$row['linklabel'].'">'.$row['linklabel'].'</a></li>';

answered Mar 19, 2013 at 17:14

artahian

2,10314 silver badges17 bronze badges

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

Comments

Alvaro · Accepted Answer · 2013-03-19 17:20:58Z

0

You have a problem with double quotes, you are closing the echo string because you are not escaping them.

I recommend you to use simple strings for the echo function:

echo '<li><a href="index.php?pid="'.$row['linklabel'].'>"'.$row['linklabel'].'"</a></li>';

If you are using double quotes, you can also use { } combined with the escaping tag \:

echo "<li><a href=\"index.php?pid=\"{$row['linklabel']}\">{$row['linklabel']}</a></li>';

Another escaping option opening and closing tags would be:

echo "<li><a href=\"index.php?pid=".$row['linklabel']."\">".$row['linklabel']."</a></li>";

edited Mar 19, 2013 at 17:20

answered Mar 19, 2013 at 17:14

Alvaro

41.7k31 gold badges174 silver badges352 bronze badges

Collectives™ on Stack Overflow

html/php SQL populated nav bar not

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related