显示字段[关闭]

Question

I have this code

$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("juliver", $con);

$result = mysql_query("SELECT * FROM menu");

$sm = "";
while($row = mysql_fetch_array($result))
{

$sm .= "<li><a href='#".$row['page'].'">'.$row['menulist']."</a></li>";

}

mysql_close($con);

?>
<? echo $sm; ?>

My database is look like this.

id    menulist          page
1     Home              tb1
2     Gallery           tb2
3     Clothing          tb3
4     Furniture         tb4
5     Household-items   tb5

the output should be this if converted into html.

<li><a href="#tb1">Home</a></li>
<li><a href="#tb2">Gallery</a></li>
<li><a href="#tb3">Clothing</a></li>
<li><a href="#tb4">Furniture</a></li>
<li><a href="#tb5">Household-items</a></li>

I tried removing, adding, renaming and etc into the code and etc. but im still stuck and none of them work.

please help me.

Answer 1

You forgot the ending ;

$sm = "<li><a href='#".$row['page']."'>".$row['menulist']."</a></li>"; //<<----there

You might want to look into finding an editor that does syntax highlighting, as this would have been an easy one for it to have shown you.