Espero que alguien me pueda ayudar con este código porque llevo dos días con él y no sé donde está el fallo porque no me muestra nada. Os dejo el código para que le deís un vistazo.
Código PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Producto</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<?php
require_once("conexion.inc.php");
$conexion = new mysqli($servidor, $usuario, $passwd, $basedatos);
if (mysqli_connect_errno())
{
echo "Error al establecer la conexión con la base de datos: " . mysqli_connect_error();
exit();
}
$resultado = $conexion->query("SELECT * FROM " . $_GET["categoria"] . " WHERE referencia=" . $_GET["referencia"]);
?>
<body bgcolor="#F5F5F5" topmargin="10">
<table width="836" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="836" height="20" bgcolor="#F5F5F5"></td>
</tr>
<tr>
<td width="836" bgcolor="#FFFFFF">
<?php
echo "<TABLE BORDER='1'>\n";
echo "<TR><TH width=160 height=20>Descripción</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Colores</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 25 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 50 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 100 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 250 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 500 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 1000 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 5000 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Precio 10000 unidades</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Codigo marcaje</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Medida marcaje</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Colores máximos</TH>\n";
echo "<TH width=9 height=20 bgcolor=#F5F5F5></TH>\n";
echo "<TH width=160 height=20>Imagen</TH></TR>\n";
while ($fila = $resultado->fetch_array())
{
echo "<TR ALIGN='center' VALING='top'>";
echo "<TD width=160 height=90>" . $fila["descripcion"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["colores"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["25"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["50"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["100"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["250"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["500"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["1000"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["5000"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["10000"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["codigo_marcaje"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["medida_marcaje"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90>" . $fila["colores_maximos"] . "</TD>\n";
echo "<TD width=9 height=90 bgcolor=#F5F5F5></TH>\n";
echo "<TD width=160 height=90><img src=\"imagenes/" . $fila["referencia"] . ".jpg\" width=90 height=90></TD>\n";
echo "</TR>\n";
}
echo "</TABLE>\n";
$resultado->close();
$conexion->close();
?>
</td>
</tr>
<tr>
<td width="836" height="20" bgcolor="#F5F5F5"></td>
</tr>
<tr>
<td width="836" height="30" bgcolor="#FFFFFF">
<a href="http://www.macromedia.com/go/getflashplayer_es" target="_blank">
<strong>flash player 7</strong>
</a>
</td>
</tr>
</table>
</body>
</html>
Código PHP:
<A HREF="producto.php?categoria=" . $_GET["categoria"] . "&referencia=" . $fila["referencia"] . "\">" . $fila["descripcion"] . "</A>
Muchas gracias.