Hi there!
I'm trying to fetch data from my Mysql db. The table has four columns. I need to put in each row a select form with db data inside. Using while() I get the data but only for the first row. Can anyone help me to get the select values/data in all rows?
The screenshot: http://ScrnSht.com/whkycz
The code in pastebin: http://pastebin.com/FcUK2twv
or here:
<?php
while ($item2 = $listado->fetch()) {
?>
<tr>
<td>Carril nº: <?php echo $item2['idCarrilTabaco'] ?><td>
<td>
<select name="descripcion" size ="1">
<?php while ($tabacos1 = $tabacos->fetch()) {?>
<option value='<?php echo $tabacos1['idTabaco']?>'><?php echo $tabacos1['descripcion']?></option>
<?php } ?>
</select>
</td>
<td><?php echo $item2['Capacidad'] ?></td>
<td><?php echo $item2['Cantidad'] ?></td>
</tr>
<?php
}
?>

Thanks all! Ban.

Solution: I created a variable using fetchAll() out of the while scope. But is there another way to do it?
It looks now like: http://pastebin.com/y1MGGT8V

It's hard to know why the first pastebin wasn't working if we don't know how the variables $listado or $tabacos were created.

P.D. Usaste mysql_query o otra funcion o clase?