Código PHP:
<table width="750" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="50">PartNo.</td>
<td width="500">Description</td>
<td width="50">Shipping</td>
<td width="50">Quantity</td>
<td width="50">Price</td>
<td width="50">Extended</td>
</tr>
<?php
include ("includes/conn.php");
$sql="SELECT ...";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result)){ //Array or records stored in $nt
echo '<tr>
<td>'.$row['qpart'].'</td>
<td>'.$row['dpname'].'</td>
<td>N/A</td>
<td>'.$row['qquantity'].'</td>
<td>'.$row['pprice'].'</td>
<td>'.$row['result'].'</td>
</tr>';
/* Option values are added by looping through the array */
}
?>
<tr>
<td colspan="5" align="right">Item Total</td>
<td> </td>
</tr>
<tr>
<td colspan="5" align="right">Estimated Freight</td>
<td> </td>
</tr>
<tr>
<td colspan="5" align="right"><font color="#FF0000">*</font>Total</td>
<td> </td>
</tr>
</table>
Código HTML:
<table width="750" border="1" cellspacing="0" cellpadding="0"> <tr> <td width="50">PartNo.</td> <td width="500">Description</td> <td width="50">Shipping</td> <td width="50">Quantity</td> <td width="50">Price</td> <td width="50">Extended</td> </tr> <tr> <td>NDNPR4848-3</td> <td>WIRE MESH PALLETS NDNPR4848-3</td> <td>N/A</td> <td>5</td> <td>37.50</td> <td>187.5</td> </tr><tr> <td>4846S-3-2545</td> <td>WIRE MESH DECK 4846S-3-2545</td> <td>N/A</td> <td>2</td> <td>14.69</td> <td>29.38</td> </tr><tr> <td>24S25</td> <td>SERIES 35 SCISSORS LIFT TABLE 24S25</td> <td>N/A</td> <td>2</td> <td>2577.60</td> <td>5155.2</td> </tr><tr> <td>P18</td> <td>HEAVY-DUTY PROTECTION P18</td> <td>N/A</td> <td>5</td> <td>28.13</td> <td>140.65</td> </tr><tr> <td>126G</td> <td>SPRING LOADED CASTER LADDERS 126G</td> <td>N/A</td> <td>4</td> <td>130.15</td> <td>520.6</td> </tr><tr> <td>33220</td> <td>AKRO-GRIDS</td> <td>N/A</td> <td>5</td> <td>14.70</td> <td>73.5</td> </tr><tr> <td>30265</td> <td>AKROBINS, ESD BINS, DIVIDERS & LIDS</td> <td>N/A</td> <td>1</td> <td>11.53</td> <td>11.53</td> </tr><tr> <td>ZLTT-5272-2-48</td> <td>ZERO LIFT AND TILT TABLES ZLTT-5272-2-48</td> <td>N/A</td> <td>2</td> <td>5121.00</td> <td>10242</td> </tr><tr> <td>33220</td> <td>AKRO-GRIDS</td> <td>N/A</td> <td>100</td> <td>14.70</td> <td>1470</td> </tr><tr> <td>30210</td> <td>AKROBINS, ESD BINS, DIVIDERS & LIDS</td> <td>N/A</td> <td>20</td> <td>0.77</td> <td>15.4</td> </tr><tr> <td>EZ201/2x36EZVPP</td> <td>E-Z PALLET LIFT EZ201/2x36EZVPP</td> <td>N/A</td> <td>4</td> <td>268.75</td> <td>1075</td> </tr><tr> <td>TG-48RH</td> <td>TRACK GUARDS TG-48RH</td> <td>N/A</td> <td>4</td> <td>95.63</td> <td>382.52</td> </tr><tr> <td></td> <td></td> <td>N/A</td> <td></td> <td></td> <td></td> </tr><tr> <td></td> <td></td> <td>N/A</td> <td></td> <td></td> <td></td> </tr> <tr> <td colspan="5" align="right">Item Total</td> <td> </td> </tr> <tr> <td colspan="5" align="right">Estimated Freight</td> <td> </td> </tr> <tr> <td colspan="5" align="right"><font color="#FF0000">*</font>Total</td> <td> </td> </tr> </table>
Código HTML:
<tr> <td></td> <td></td> <td>N/A</td> <td></td> <td></td> <td></td> </tr>
P.S.
La BDD solo tiene los 12 resultados que esta arrojando, no tiene nada en blanco