- 论坛徽章:
- 0
|
本帖最后由 luochaovg 于 2012-08-23 21:22 编辑
代码
——————————————————————————————————————————————————————————-
<?php
require 'function/mysql_connect.php';
$select="SELECT type FROM `multilayer_var` group by type;";
$result=mysql_query($select);
?>
<table width="1067" height="209" border="1" id="customers">
<tr>
<td width="182" rowspan="3">Part Number </td>
<td colspan="2">Max.Working Voltage(<20ua) </td>
<td width="107"><p>Varistor</p>
<p>Voltage</p></td>
<td colspan="2"><p>Max.Claming</p>
<p>Voltage</p></td>
<td colspan="2"><p>Rated Single Pulse</p>
<p>Transient </p></td>
<td width="157"><p>Typical</p>
<p>Capacitance</p></td>
<td width="182" rowspan="3">datasheet</td>
</tr>
<tr>
<td width="91" height="62">DC</td>
<td width="91"><p>AC</p>
<p>RMS</p></td>
<td>@1mADC</td>
<td width="93">8/20us</td>
<td width="93">ESD</td>
<td width="100"><p>Energy</p>
<p>10/1000us</p></td>
<td width="100"><p>Peak Current</p>
<p>8/20us </p></td>
<td><p>@0.5Vrms</p>
<p>1MHZ</p></td>
</tr>
<tr>
<td height="32">Vwdc(V) </td>
<td>Vwar(v)</td>
<td>Vb(V)</td>
<td> VC.1(V) </td>
<td>VC.2(2)</td>
<td>Et</td>
<td>Lp(A)</td>
<td>C(pF)</td>
</tr>
<?php while($rows=mysql_fetch_array($result)){?>
<tr>
<td colspan="10" height="30"><?php echo $rows['type']?></td>
</tr>
<?php
$rows=$rows['type'];
$select2="select * from multilayer_var where type like '$rows%' limit 0,2 ";
$result2=mysql_query($select2);
?>
<?php while($rows2=mysql_fetch_array($result2)) {?>
<tr>
<td width="182"><?php echo $rows2['Part_num']?></td>
<td width="91"><?php echo $rows2['VWDC']?></td>
<td width="91"><?php echo $rows2['VWAC']?></td>
<td width="93"><?php echo $rows2['VB']?></td>
<td width="93"><?php echo $rows2['VC1']?></td>
<td width="100"><?php echo $rows2['VC2']?></td>
<td width="100"><?php echo $rows2['ET']?></td>
<td width="100"><?php echo $rows2['LP']?></td>
<td width="182"><?php echo $rows2['C']?></td>
<td width="182"><?php echo $rows2['Datasheet']?></td>
</tr>
<?php }?>
<?php }?>
</table>
————————————————————————————————————————————————————————————————————
这个我想实现翻页功能,由于用到了内循环我不知道怎么去实现,求解决!
|
|