Tengo este codigo, que me muestra todos los registros de una base llamada productos, a modo formulario.
Código PHP:
<?PHP
$result = mysql_query ("SELECT * FROM he_productos WHERE categ='Motherboards' AND rubro='hard'");
$numeroRegistros=mysql_num_rows($result);
while($r=mysql_fetch_array($result))
{
$idproducto=$r["idproducto"];
$desc=$r["desc"];
$categ=$r["categ"];
$preciop=$r["preciop"];
$preciog=$r["preciog"];
$novedad=$r["novedad"];
$oferta=$r["oferta"];
$mostrar=$r["mostrar"];
$garantia=$r["garantia"];
$masinfo=$r["masinfo"];
$rubro=$r["rubro"];
$fechai=$r["fechai"];
$marca=$r["marca"];
$img=$r["img"];
echo "<table width='100%' border='0' cellpadding='3' cellspacing='2'>\n";
echo "<tr>\n";
echo "<td colspan='3' bgcolor='#000000'><input name='desc' type='text' id='desc' value='$desc' size='60' /></td>\n";
echo "<td width='43%' bgcolor='#000000'><table width='100%' border='0' cellspacing='0' cellpadding='0'>\n";
echo "<tr>\n";
echo "<td bgcolor='#000000'><div align='center'>Precio\n";
echo "publico:\n";
echo "<input name='preciop' type='text' id='preciop' value='$preciop' size='7' />\n";
echo "</div></td>\n";
echo "<td bgcolor='#000000'><div align='center'>Precio gremio:\n";
echo "<input name='preciog' type='text' id='preciog' value='$preciog' size='7' />\n";
echo "</div></td>\n";
echo "</tr>\n";
echo "</table></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan='2' bgcolor='#000000'>\n";
echo "Categoria: <input name='categ' type='text' id='categ' value='$categ' size='20' />\n";
echo "</div></td>\n";
echo "<td width='29%' bgcolor='#000000'><div align='center'>Garantia</div></td>\n";
echo "<td rowspan='4' bgcolor='#000000'><div align='center'>Mas Info:<br />\n";
echo "<textarea name='masinfo' cols='40' rows='4' id='masinfo'>$masinfo</textarea>\n";
echo "<br />\n";
echo "<input name='idproducto' type='hidden' id='idproducto' value='$idproducto' />\n";
echo "<input name='rubro' type='hidden' id='rubro' value='$rubro' />\n";
echo "<input name='fechai' type='hidden' id='fechai' value='$fechai' />\n";
echo "<input name='fechaa' type='hidden' id='fechaa' value='date ("d-m-y");' />\n";
echo "<input name='marca' type='hidden' id='marca' value='$marca' />\n";
echo "<br />\n";
echo "<br />\n";
echo "</div></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td width='9%' height='20' bgcolor='#000000'><div align='center'>¿En Stock? </div></td>\n";
echo "<td width='19%' bgcolor='#000000'><div align='center'>\n";
echo "<input name='mostrar' type='text' id='mostrar' value='$mostrar' size='5' />\n";
echo "</div></td>\n";
echo "<td height='20' bgcolor='#000000'><div align='center'>\n";
echo "<input name='garantia' type='text' id='garantia' value='$garantia' size='20' />\n";
echo "</div></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td height='20' bgcolor='#000000'><div align='center'>¿Es novedad? </div></td>\n";
echo "<td height='20' bgcolor='#000000'><div align='center'>\n";
echo "<input name='novedad' type='text' id='novedad' value='$novedad' size='5' />\n";
echo "</div></td>\n";
echo "<td height='20' bgcolor='#000000'><div align='center'>Imagen</div></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td height='20' bgcolor='#000000'><div align='center'>¿Es oferta? </div></td>\n";
echo "<td height='20' bgcolor='#000000'><div align='center'>\n";
echo "<input name='oferta' type='text' id='oferta' value='$oferta' size='5' />\n";
echo "</div></td>\n";
echo "<td height='20' bgcolor='#000000'><div align='center'>\n";
echo "<input name='img' type='text' id='img' value='$img' size='20' />\n";
echo "</div></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "<br>\n";
}
?>
Bueno, haciendola corta, como hago para actualizar todos los registros a la vez?
Muchas gracias!