php+mysql新手提问。。。。。。。超值分数等你来拿

Question

$sql="select * from T_goods";
$result=mysql_query($sql,$db) or die(mysql_error());
while($row=mysql_fetch_array($result)){
  echo $row["goodsname"].$row["goodspic"].substr($row["goodscontent"],0,50);
}

Answer 1

<table>
<?php
$sql="select * from T_goods";
$result=mysql_query($sql,$db) or die(mysql_error());
while($row=mysql_fetch_array($result)){
?>
<tr><td><?php echo $row["goodsname"];?></td><td><?php echo $row["goodspic"];?></td><td><?php echo substr($row["goodscontent"],0,50);?></td></tr>
<?php
}
?>
</table>

Answer 2

<table>
<?php
$sql="select * from T_goods";
$result=mysql_query($sql,$db) or die(mysql_error());
while($row=mysql_fetch_array($result)){
?>
<tr>
<td><?php echo $row["goodsname"];?></td>
<td><a href="XX.php"><img src="<?php echo $row["goodspic"];?>"/></a></td>
<td><?php echo substr($row["goodscontent"],0,50);?></td></tr>
<?php
}
?>
</table>

Answer 3

$sql="select * from T_goods";
$result=mysql_query($sql,$db) or die(mysql_error());
while($row=mysql_fetch_array($result)){
  echo $row["goodsname"].$row["goodspic"].substr($row["goodscontent"],0,50);
}