简易在线投票系统php——主页获取信息

<!--主体内容-->
        	<?php
				$sql="select vid,vname,starttime,uid,vintro from vote order by vid DESC";
				$voteItem=mysql_query($sql);
				//循环获取数据库信息
				while($row=mysql_fetch_array($voteItem)){
					$sql2="SELECT username FROM users where uid=".$row['uid'];
					$uname=mysql_query($sql2);
					$username=mysql_fetch_row($uname);
					//截取前100个字
					$intro=substr($row['vintro'],0,300)."……";
					//输出
					echo "<div class='contend_item'>".
							"<table>".
								"<tr><td class='contend_item_name'><a href='./select.php?user=".$ouser."&vid=".$row['vid']."'>".$row['vname']."</a></td><td>发 布 者：".$username[0]."<br/>发布日期：".$row['starttime']."</td></tr>".
								"<tr><td colspan='2'>&#160;&#160;".$intro."</td></tr>".
							"</table>".
						"</div>";
				}
        	?>
		<!--主体内容结束-->

$sql="select vid,vname,starttime,uid,vintro from vote order by vid DESC";
$voteItem=mysql_query($sql);

$intro=substr($row['vintro'],0,300)."……";