Hola chicos, veran, estoy intentando armar una tabla de acuerdo a los resultados que arroje una consulta SQL, tengo esto:
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>
Pero al momento de ejecutar, me regresa:
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>
Como ven, me agrega 2
Código HTML:
<tr>
<td></td>
<td></td>
<td>N/A</td>
<td></td>
<td></td>
<td></td>
</tr>
extras, y no se porke podria estarlo haciendo, alguien tiene una idea del porke podria estar haciendolo?
P.S.
La BDD solo tiene los 12 resultados que esta arrojando, no tiene nada en blanco