MySQL的获取数组，表结果 [英] Mysql fetch array, table results

问题描述

我对此很陌生，不知道该怎么办

i'm pretty new to this and not sure how should i do it,

我有一个名为名称"列的数据库

I've got a database with a column called "names"

我怎样才能使其如此显示?

how can i make it display in so?

  <tr>
  <td width="270px">Henry</td>
  <td width="270px">Jeffrey</td>
  <td width="270px">Hansel</td>
  </tr>

  <tr>
  <td width="270px">Michelle</td>
  <td width="270px">Jackson</td>
  <td width="270px">Ivan</td>
  </tr>

我只知道如果记录在垂直方向上一个接一个地记录，我应该怎么做.

I only know how i should do it if the records goes one after another vertically.

  $result = mysql_query('SELECT * FROM member');

  while($row = mysql_fetch_array($result))
  {
  echo'
  <tr>
  <td width="270px">'.$row['names'].'</td>
  <td width="270px">Jeffrey</td>
  <td width="270px">Hansel</td>
  </tr>';

Kinda卡在这里...

Kinda stucked here...

对不起，我忘记了这个.

Sorry i forgot to put this.

我想要的是它应该沿着标签循环.这样我就可以拥有一个包含无限行的3列表.

what i want is that it should loop the tags along. So i can have a 3 column table with infinite rows.

这回合是什么?如果我想让它循环播放怎么办?

what bout this one? What if i want this to loop instead?

<tr>
<td><img src="images/ava/A.png" /></td>
<td>A</td>
<td width="2px" rowspan="3"></td>
<td><img src="images/ava/B.png" /></td>
<td>B</td>
</tr>


<tr>
<td>A</td>
<td>B</td>
</tr>

推荐答案

$row将在循环的每次迭代中更新:

$row will update on each iteration of the loop:

$result = mysql_query('SELECT * FROM member');

echo '<tr>';

for($i = 0; $row = mysql_fetch_array($result); $i = ($i+1)%3){
    echo '<td width="270px">'.$row['names'].'</td>';
    if($i == 2)
        echo '</tr><tr>';
}

echo '</tr>';

这篇关于MySQL的获取数组，表结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！