Código PHP:
elseif ($_POST['modificar'])
{
$resultado = mysql_query("SELECT * FROM " . $_POST["subCategoria"]);
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Referencia:</td>";
echo "<td colspan=2 width=209><select name=\"referencia\">";
while ($fila = mysql_fetch_array($resultado))
{
echo "<option value=\"" . $fila["referencia"] . "\">" . $fila["referencia"] . "</option></select>";
}
echo "</td>";
$producto = mysql_query("SELECT * FROM " . $_POST["subCategoria"] . " WHERE referencia = " . $_POST["referencia"]);
$elProducto = mysql_fetch_array($producto);
echo "<td colspan=2 width=209>Código de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"codigo_marcaje\" type=\"text\" id=\"codigo_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["codigo_marcaje"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Descripción:</td>";
echo "<td colspan=2 width=209><input name=\"descripcion\" type=\"text\" id=\"descripcion\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["descripcion"] . "</td>";
echo "<td colspan=2 width=209>Medida de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"medida_marcaje\" type=\"text\" id=\"medida_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["medida_marcaje"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Colores:</td>";
echo "<td colspan=2 width=209><input name=\"colores\" type=\"text\" id=\"colores\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["colores"] . "</td>";
echo "<td colspan=2 width=209>Colores máximos de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"colores_maximos\" type=\"text\" id=\"colores_maximos\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["colores_maximos"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Precio según las unidades:</td>";
echo "<td colspan=2 width=209></td>";
echo "<td colspan=2 width=209>Incremento:</td>";
echo "<td colspan=2 width=209><input name=\"incremento\" type=\"text\" id=\"incremento\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["incremento"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>25</td>";
echo "<td><input name=\"25\" type=\"text\" id=\"25\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["25"] . "</td>";
echo "<td>100</td>";
echo "<td><input name=\"100\" type=\"text\" id=\"100\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["100"] . "</td>";
echo "<td>500</td>";
echo "<td><input name=\"500\" type=\"text\" id=\"500\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["500"] . "</td>";
echo "<td>5000</td>";
echo "<td><input name=\"5000\" type=\"text\" id=\"5000\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["5000"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>50</td>";
echo "<td><input name=\"50\" type=\"text\" id=\"50\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["50"] . "</td>";
echo "<td>250</td>";
echo "<td><input name=\"250\" type=\"text\" id=\"250\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["250"] . "</td>";
echo "<td>1000</td>";
echo "<td><input name=\"1000\" type=\"text\" id=\"1000\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["1000"] . "</td>";
echo "<td>10000</td>";
echo "<td><input name=\"10000\" type=\"text\" id=\"10000\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["10000"] . "</td>";
echo "</tr>";
}
else
{
$resultado = mysql_query("SELECT * FROM " . $_POST["subCategoria"]);
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Referencia:</td>";
echo "<td colspan=2 width=209><select name=\"referencia\">";
while ($fila = mysql_fetch_array($resultado))
{
echo "<option value=\"" . $fila["referencia"] . "\">" . $fila["referencia"] . "</option></select>";
}
echo "</td>";
$producto = mysql_query("SELECT * FROM " . $_POST["subCategoria"] . " WHERE referencia = " . $_POST["referencia"]);
$elProducto = mysql_fetch_array($producto);
echo "<td colspan=2 width=209>Código de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"codigo_marcaje\" type=\"text\" id=\"codigo_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["codigo_marcaje"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Descripción:</td>";
echo "<td colspan=2 width=209><input name=\"descripcion\" type=\"text\" id=\"descripcion\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["descripcion"] . "</td>";
echo "<td colspan=2 width=209>Medida de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"medida_marcaje\" type=\"text\" id=\"medida_marcaje\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["medida_marcaje"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Colores:</td>";
echo "<td colspan=2 width=209><input name=\"colores\" type=\"text\" id=\"colores\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["colores"] . "</td>";
echo "<td colspan=2 width=209>Colores máximos de marcaje:</td>";
echo "<td colspan=2 width=209><input name=\"colores_maximos\" type=\"text\" id=\"colores_maximos\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["colores_maximos"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td colspan=2 width=209>Precio según las unidades:</td>";
echo "<td colspan=2 width=209></td>";
echo "<td colspan=2 width=209>Incremento:</td>";
echo "<td colspan=2 width=209><input name=\"incremento\" type=\"text\" id=\"incremento\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["incremento"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>25</td>";
echo "<td><input name=\"25\" type=\"text\" id=\"25\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["25"] . "</td>";
echo "<td>100</td>";
echo "<td><input name=\"100\" type=\"text\" id=\"100\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["100"] . "</td>";
echo "<td>500</td>";
echo "<td><input name=\"500\" type=\"text\" id=\"500\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["500"] . "</td>";
echo "<td>5000</td>";
echo "<td><input name=\"5000\" type=\"text\" id=\"5000\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["5000"] . "</td>";
echo "</tr>";
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"8\" width=\"836\" height=\"8\"></td></tr>";
echo "<tr bgcolor=\"#FFFFFF\">";
echo "<td>50</td>";
echo "<td><input name=\"50\" type=\"text\" id=\"50\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["50"] . "</td>";
echo "<td>250</td>";
echo "<td><input name=\"250\" type=\"text\" id=\"250\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["250"] . "</td>";
echo "<td>1000</td>";
echo "<td><input name=\"1000\" type=\"text\" id=\"1000\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["1000"] . "</td>";
echo "<td>10000</td>";
echo "<td><input name=\"10000\" type=\"text\" id=\"10000\" size=\"20\" style=\"background-color:#F5F5F5\" />" . $elProducto["10000"] . "</td>";
echo "</tr>";
}
?>
<tr bgcolor="#FFFFFF">
<td colspan="8" width="836" height="16"></td>
</tr>
<tr>
<td colspan="8" width="836" height="22" bgcolor="#F5F5F5">
</tr>
</table>
<script>crearSubSelect()</script>
</body>
</html>
Ya siento tenerlo que poner así pero es que no me deja ponerlo todo junto.
De los botones no consigo que me coja el if que es sino que siempre me coge el else. Es otra tarea pendiente.