Hola a todos:
necesito poder paginar esta consulta de Mysql
porfavor alguien me puede echar una mano? he probado con el Paginator1.6
pero como soy muy novato en esto necesito que alguien me ayude.
este es el codigo, y como puede ver al final esta la sentencia PRINT
que imprime los campos aue necsito aue aparezcan
<?php
$conn = mysql_connect("x.com", "xxxx", "xxxx"); // datos SQL
mysql_select_db("xxxxx", $conn); // Nombre de la B.D
$sql = "SELECT * FROM products_to_categories ORDER BY products_id";
$records = mysql_query($sql, $conn);
Print "<table border=3 width=100% class='infoBoxContent'>";
Print "<tr><td>Ref</td><td>Categoría</td><td>Imagen</td><td>Descripción</td> <td>Precio</td> <td>PVD</td></tr>";
$i = 0;
while ($table = mysql_fetch_array($records)) {
$product = $table['products_id'];
$category = $table['categories_id'];
$desc_id = $product;
$sql = "SELECT categories_name, categories_id FROM categories_description WHERE categories_id = $category";
$category = mysql_query($sql, $conn);
$category = mysql_fetch_array($category);
$category = $category['categories_name'];
$sql = "SELECT products_id, products_model, products_price, products_pvd, products_image FROM products WHERE products_id = $product";
$product = mysql_query($sql, $conn);
$product = mysql_fetch_array($product);
$part = $product['products_id'];
$price = $product['products_price'];
$pvd = $product['products_pvd'];
$picture = $product['products_image'];
$price = substr($price,0, strlen($price) - 2);
$sql = "SELECT products_id, products_description FROM products_description WHERE products_id = $desc_id";
$description = mysql_query($sql, $conn);
$description = mysql_fetch_array($description);
$description = $description['products_description'];
if (!($i%2)) {
$color = "BGCOLOR = #FFFF99";
}
else {
$color = "BGCOLOR = #FFFFFF";
}
print "<tr><td>$part</td><td>$category</td><td>$picture</td><td>$description</td><td>$$price</td><td>$pvd</td></tr>";
$i++;
}
print "</table>"
?>
