select a.value,a.data1,a.data2,a.period,b.name,b.main_url from 表2 a,表1 b where
a.period in (1,2,3) and a.name=nb_visits and a.idsite = b.idsite order
by a.value desc;
代碼:
<td><div><?php echo $row['name']?></div></td>
<td><div><?php echo $row['main_url']?></div></td>
<td><div><?php if($row['period'] == 1){echo $row['value'];} ?></div></td> 當period=1的時候 輸出value
<td><div><?php if($row['period'] == 2){echo $row['value'];}?></div></td>當period=2的時候 輸出value
<td><div><?php if($row['period'] == 3){echo $row['value'];}?></div></td>當period=3的時候 輸出value
哥們,如果解決了,千萬別忘了采納哦,呵呵。