Ver Mensaje Individual
  #1 (permalink)  
Antiguo 12/01/2010, 15:02
Avatar de JessicaTJ
JessicaTJ
 
Fecha de Ingreso: enero-2007
Ubicación: 127.0.0.1
Mensajes: 472
Antigüedad: 17 años, 3 meses
Puntos: 25
Bucle segun consulta MySQL

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>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="5" align="right">Estimated Freight</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="5" align="right"><font color="#FF0000">*</font>Total</td>
    <td>&nbsp;</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>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="5" align="right">Estimated Freight</td>
    <td>&nbsp;</td>
  </tr>
  <tr>

    <td colspan="5" align="right"><font color="#FF0000">*</font>Total</td>
    <td>&nbsp;</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
__________________
٩(͡๏̯͡๏)۶ || ٩(͡๏̯͡๏)۶