dougan1205 2013-12-07 08:20
浏览 28
已采纳

动态表格式

i have this table to display data from my database dynamically

<table border="1">
        <th>PO</th>
        <th>Fuel Details ID</th>
        <th>Date</th>
        <th>Price</th>
        <th>Liters</th>
        <th>Previous Balance</th>
        <th>Hobo</th>
        <th>Truck ID</th>
        <th>Fuel Source</th>
        <th>Date</th>
        <th>Route</th>
        <th>Destination</th>
        <th>Number of Vans</th>
        <th>Stripping</th>
        <th>Truck ID</th>
        <th>Customer ID</th>
        <th>Driver ID</th>
        <th>PO ID</th>
        <th>Waybill ID</th>

        <?php do { ?>
        <tr>
            <td><?php echo $row_PKFD['tbl_po_id_po']; ?></td>
            <td><?php echo $row_PKFD['id_fuel_details']; ?></td>
            <td><?php echo $row_PKFD['fuel_details_date']; ?></td>
            <td><?php echo $row_PKFD['fuel_details_price']; ?></td>
            <td><?php echo $row_PKFD['fuel_details_liters']; ?></td>
            <td><?php echo $row_PKFD['fuel_details_previous_bal']; ?></td>
            <td><?php echo $row_PKFD['fuel_details_hobo']; ?></td>
            <td><?php echo $row_PKFD['tbl_truck_id_truck']; ?></td>
            <td><?php echo $row_PKFD['tbl_fuel_source_id_fuel_source']; ?></td>

            <?php do { ?>
            <td><?php echo $row_PKDD['delivery_details_date']?></td>
            <td><?php echo $row_PKDD['delivery_details_route']?></td>
            <td><?php echo $row_PKDD['delivery_details_destination']?></td>
            <td><?php echo $row_PKDD['delivery_details_van_no']?></td>
            <td><?php echo $row_PKDD['delivery_details_strip_stuff']?></td>
            <td><?php echo $row_PKDD['tbl_truck_id_truck']?></td>
            <td><?php echo $row_PKDD['tbl_customer_id_customer']?></td>
            <td><?php echo $row_PKDD['tbl_driver_id_driver']?></td>
            <td><?php echo $row_PKDD['tbl_po_id_po']?></td>
            <td><?php echo $row_PKDD['tbl_waybill_id_waybill']?></td>
        </tr>
        <?php } while ($row_PKDD = mysql_fetch_assoc($PKDD)); ?>
        <?php } while ($row_PKFD = mysql_fetch_assoc($PKFD)); ?>
</table>

the first displays the first instance if the program finds two or more data related to the first it will make another which is in the below code as you can see my problem is when i display the first and the first instance of the second are aligned but when the program finds another data related to the first it will make another but not inline on the second i want it to show that the first will be aligned with the first instance of the second and the second instance of the second will be below the first instance of the second

What is being displayed

What i want displayed

The first picture shows what is displayed by the code

the second picture shows what i want to display

  • 写回答

1条回答 默认 最新

  • dqqyp90576 2013-12-07 09:17
    关注
    <table border="1">
        <tr>
            <th>PO</th>
            <th>Fuel Details ID</th>
            <th>Date</th>
            <th>Price</th>
            <th>Liters</th>
            <th>Previous Balance</th>
            <th>Hobo</th>
            <th>Truck ID</th>
            <th>Fuel Source</th>
            <th>Date</th>
            <th>Route</th>
            <th>Destination</th>
            <th>Number of Vans</th>
            <th>Stripping</th>
            <th>Truck ID</th>
            <th>Customer ID</th>
            <th>Driver ID</th>
            <th>PO ID</th>
            <th>Waybill ID</th>
        </tr>
        <?php do { ?>
            <tr>
                <td><?php echo $row_PKFD['tbl_po_id_po']; ?></td>
                <td><?php echo $row_PKFD['id_fuel_details']; ?></td>
                <td><?php echo $row_PKFD['fuel_details_date']; ?></td>
                <td><?php echo $row_PKFD['fuel_details_price']; ?></td>
                <td><?php echo $row_PKFD['fuel_details_liters']; ?></td>
                <td><?php echo $row_PKFD['fuel_details_previous_bal']; ?></td>
                <td><?php echo $row_PKFD['fuel_details_hobo']; ?></td>
                <td><?php echo $row_PKFD['tbl_truck_id_truck']; ?></td>
                <td><?php echo $row_PKFD['tbl_fuel_source_id_fuel_source']; ?></td>
    
                <?php 
                if(!mysql_fetch_assoc($PKDD)){
                    ?><td colspan='10'></td><?php
                }else{
                    ?>
                    do {
                        $i=0;
                        if($i > 0){
                            ?></tr><tr><td coslpan='9'></td><?php
                        }
                        <td><?php echo $row_PKDD['delivery_details_date']?></td>
                        <td><?php echo $row_PKDD['delivery_details_route']?></td>
                        <td><?php echo $row_PKDD['delivery_details_destination']?></td>
                        <td><?php echo $row_PKDD['delivery_details_van_no']?></td>
                        <td><?php echo $row_PKDD['delivery_details_strip_stuff']?></td>
                        <td><?php echo $row_PKDD['tbl_truck_id_truck']?></td>
                        <td><?php echo $row_PKDD['tbl_customer_id_customer']?></td>
                        <td><?php echo $row_PKDD['tbl_driver_id_driver']?></td>
                        <td><?php echo $row_PKDD['tbl_po_id_po']?></td>
                        <td><?php echo $row_PKDD['tbl_waybill_id_waybill']?></td>
                        if($i > 0){
                            ?></tr><tr><?php
                        }
                        $i++;   
                    } while ($row_PKDD = mysql_fetch_assoc($PKDD));
                } 
                ?>
            </tr>
        <?php } while ($row_PKFD = mysql_fetch_assoc($PKFD)); ?>
    </table>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 微信小程序协议怎么写
  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看