<?
$connect=mysql_connect("localhost","root","*******");
$select=mysql_select_db("xyz");
$result=mysql_db_query("select * from hehe");
echo '<table border="1" bgcolor="green" bordercolor="#336666">'.
if (mysql_num_rows($result)<1){
echo "<tr><td>没有返回的数据!</td></tr>"
}else{
while($row=mysql_fetch_row($result)){
$m1=$row[0];
$m2 = $row[1];
$m3 = $row[2];
$m4 = $row[3];
$m5 = $row[4];
$pic= '<img src="images/real.gif">';
echo "<tr>".
'<td>'.$m1.'</td>'.
'<td>'.$m2.'</td>'.
'<td>'.$m3.'</td>'.
'<td>'.$m4.'</td>'.
'<td>'.'<a href=$m5>'.$pic.'</a>'.'</td>'.
'</tr>';
}}
echo '</table>';
?>
$connect=mysql_connect("localhost","root","*******");
$select=mysql_select_db("xyz");
$result=mysql_db_query("select * from hehe");
echo '<table border="1" bgcolor="green" bordercolor="#336666">'.
if (mysql_num_rows($result)<1){
echo "<tr><td>没有返回的数据!</td></tr>"
}else{
while($row=mysql_fetch_row($result)){
$m1=$row[0];
$m2 = $row[1];
$m3 = $row[2];
$m4 = $row[3];
$m5 = $row[4];
$pic= '<img src="images/real.gif">';
echo "<tr>".
'<td>'.$m1.'</td>'.
'<td>'.$m2.'</td>'.
'<td>'.$m3.'</td>'.
'<td>'.$m4.'</td>'.
'<td>'.'<a href=$m5>'.$pic.'</a>'.'</td>'.
'</tr>';
}}
echo '</table>';
?>
for ($i=0; $i<$num; $i++)
{
@mysql_data_seek($result, $i);//将结果集读入变量$result
$data = @mysql_fetch_array($result, MYSQL_ASSOC);
$m1 = $row[0]; //m1,m2...是字段,不是记录。
$m2 = $row[1];
$m3 = $row[2];
$m4 = $row[3];
$m5 = $row[4];
echo '<table border="1" bgcolor="green" bordercolor="#336666">'.
'<tr>'.
'<td>'.$m1.'</td>'.
'<td>'.$m2.'</td>'.
'<td>'.$m3.'</td>'.
'<td>'.$m4.'</td>'.
'<td>'.'<a href=$m5>'.$pic.'</a>'.'</td>'.
'</tr>'.
'</table>';
}
?>
$connect=mysql_connect("localhost","root","*******");
$select=mysql_select_db("xyz",$connect);
$result=mysql_db_query("xyz","select * from hehe");
$num=mysql_num_rows($result); $pic= '<img src="images/real.gif">';
while(list($m1,$m2,$m3,$m4,$m5)=mysql_fetch_row($result);) {
echo '<table border="1" bgcolor="green" bordercolor="#336666">'.
'<tr>'.
'<td>'.$m1.'</td>'.
'<td>'.$m2.'</td>'.
'<td>'.$m3.'</td>'.
'<td>'.$m4.'</td>'.
'<td>'.'<a href=$m5>'.$pic.'</a>'.'</td>'.
'</tr>'.
'</table>';
}