What's wrong with the standard LIMIT??
Something like this:
---------------------------------------
<?
echo "
<HTML><HEAD><TITLE>Product List (4 UP)</TITLE></HEAD>
<FORM ACTION="this_program.php" METHOD='POST'>
";

if (!isset($page)) $page = 0;

$sql = "
SELECT *
FROM    products
WHERE   prod_cat = $cat_ID LIMIT $page,4";
$mysql_result=mysql_query($sql,$connection);
while ($row     = mysql_fetch_array($mysql_result)
{
$prod_name 
= $row["prod_name"];
$prod_image 
= $row["prod_image"];
$prod_ID 
= $row["ID"];
echo "<img src=\"products/$prod_image\" border=0 
height=150><br>$prod_name<br><br>";
}
$page 
+= 4;
echo "
<INPUT TYPE='HIDDEN' NAME='page' VALUE='$page'>
<INPUT TYPE='SUBMIT' NAME='Submit' VALUE='Next 4'>
</FORM>
";
?>
-----------------------------------------------
Or is this not what you are after.
HTH. Good luck..
Dan





Jen Swofford wrote:

> Time for a slightly less-newbie question than before from me.  Believe me,
> I've RTF'nM and I'm *not* getting this.  :(
> 
> So I am currently displaying all products from one product category:
> 
> $sql2="select * FROM products WHERE prod_cat = $cat_ID";
> $mysql_result=mysql_query($sql2,$connection);
> $num_rows=mysql_num_rows($mysql_result);
> if ($num_rows==0){
>       echo "no results";
> } else {
>       while ($row=mysql_fetch_array($mysql_result)){
>               $prod_name=$row["prod_name"];
>               $prod_image=$row["prod_image"];
>               $prod_ID=$row["ID"];
>               echo "<img src=\"products/$prod_image\" border=0
> height=150><br>$prod_name<br><br>";
>       }
> }
> 
> What I'm trying to do is have the ability to page through the database just
> 4 products at a time.  (This is a regular online catalog and I'm just trying
> to have a "next 4 products" link on the category page.)  I know how to
> display only 4 products.  What I can't figure out is to remember where I was
> in displaying them.  I'm thinking "array" here... but the arrays we
> typically get are of the fields in the database, not the rows.  I want an
> array that stores all the rows, not all the fields.  What am I missing?
> 
> The logic I've come up with is to do this:
> 
> $sql2="select * FROM products WHERE prod_cat = $cat_ID";
> $mysql_result=mysql_query($sql2,$connection);
> $num_rows=mysql_num_rows($mysql_result);
> if ($num_rows==0){
>       echo "no results";
> } else {
>       while ($row=mysql_fetch_array($mysql_result)){
>               // 1) create an array of all the product_id's in the result (one from 
>each
> row)
>               // 2) then select product_id 4 at a time and display them on the page
>               //    ... but that'd be a buttload of db hits
>       }
> }
> 
> I can't even quite figure out the logic here.  If anybody is interested in
> simply pointing me in the right direction, like say, "Jen, don't you know
> about mysql_fetch_jen's_type_of_array?!" then perhaps I can figure it out
> from there.  Thank you very much in advance.
> 
> Jen Swofford
> [EMAIL PROTECTED]
> 
> 
> 
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to