$result = mysql_query("SELECT * FROM Product group by p_class limit 40");while($row = mysql_fetch_array($result))
{
echo nl2br($row['p_class']);
}
这样的结果就是把p_class直接一个挨着一个全部显示到一行上了.我的目的是,每个不同的p_class都要自成一列。记得在ASP里是用循环搞定的:[code=ASP]<%
dim iiiiiiii = 1 do while not rs2.eof
%>
<tr bgcolor="#FFFFFF" align="center">
<td><%=iiii%></td>
<td><%=rs2("ab_jkdw")%></td>
</tr>
<%
rs2.movenext
iiii = iiii + 1
loop
%></table>
<p>
<%
call rs2close()
call connclose()%>[/code]PHP里我还不知道该怎么写,麻烦大家推荐一下,谢谢!
echo '<table>';
echo '<tr bgcolor="#FFFFFF" align="center">';
while($row = mysql_fetch_array($result))
{
echo "<td>$row['p_class']</td>"; }
echo '</tr>';
echo '</table>';
刚入门,瞎测试出来的:
<?php
include_once('conn.php');$result = mysql_query("SELECT p_class FROM Product group by p_class limit 40"); mysql_data_seek($result, 0);
while ($row=mysql_fetch_row($result))
{
echo "<table>\n";
echo "<tr>\n";
for ($i=0; $i<mysql_num_fields($result); $i++ )
{
echo '<td align="center">';
echo "$row[$i]";
echo '</td>';
}
echo "</tr>\n";
}
echo "</table>\n";
mysql_free_result($result);
mysql_close($conn);
?>
乔丹这段更简单,我试了试,这段代码嵌入后报错:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in D:\setup\xampp\htdocs\qry.php on line 9第九行是:echo "<td>nl2br($row['p_class'])</td>";
echo "<td>".nl2br($row['p_class'])."</td>";上面的语法错误是因为$row['p_class'] 写成 {$row['p_class']}