Here is the entire code i am working with, like i say getting same row 4 times not what i would like want all 16 records in a 4colsx4rows table.

PHP Code:

<?php
require_once '../lib/configs.php';

// If current page number, use it 
// if not, set one! 

if(!isset($_REQUEST['page'])){ 
    $page = 1; 
} else { 
    $page = $_REQUEST['page']; 
} 

// Define the number of results per page 
$max_results = 16; 

// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results);

// Perform MySQL query on only the current page number's results 
$query = "SELECT * FROM ship_to LIMIT ".$from.", ".$max_results."";
echo "<table cellpadding=5 cellspacing=1 border=0 align=center bgcolor=#000000>\n";
$bgcolor = "#E0E0E0"; // light gray 
if (mysql_connect($defaults["db_server"], $defaults["db_username"], $defaults["db_password"])) {
    if (mysql_select_db($defaults["db_database"])) {
        if ($result = mysql_query($query)) {
            if (mysql_num_rows($result) > 0) {
                while ($row = mysql_fetch_assoc($result)) {
                    if($bgcolor == "#E0E0E0"){
                        $bgcolor = "#FFFFFF";
                    }else{
                        $bgcolor = "#E0E0E0";
                    } 
                    echo "<tr bgcolor=".$bgcolor.">\n";
                    for ($i=0; $i!=4; $i++) {
                        echo "\t<td>".$row['name']."</td>\n";
                    }
                    echo "</tr>\n";
                }
            }
            mysql_free_result($result);
        }
        else {
            die ("<h3>SQL Error #".mysql_errno()."</h3>\n<h4>".mysql_error()."</h4>\n<h4>Line ".__LINE__." in ".__FILE__."</h4>\n");
        }
    }
    else {
        die ("<h3>SQL Error #".mysql_errno()."</h3>\n<h4>".mysql_error()."</h4>\n<h4>Line ".__LINE__." in ".__FILE__."</h4>\n");
    }
}
else {
    die ("<h3>SQL Error #".mysql_errno()."</h3>\n<h4>".mysql_error()."</h4>\n<h4>Line ".__LINE__." in ".__FILE__."</h4>\n");
}
echo "</table>\n";
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ship_to"),0); 

// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 

// Build Page Number Hyperlinks 
echo "<center>Select a Page<br />\n"; 

// Build Previous Link 
if($page > 1){ 
    $prev = ($page - 1); 
    echo "<a href=\"pages.php?page=$prev\">&lt;&lt;Previous</a>\n "; 
} 

for($i = 1; $i <= $total_pages; $i++){ 
    if(($page) == $i){ 
        echo "$i "; 
        } else { 
            echo "<a href=\"pages.php?page=$i\">$i</a> \n"; 
    } 
} 

// Build Next Link 
if($page < $total_pages){ 
    $next = ($page + 1); 
    echo "<a href=\"pages.php?page=$next\">Next&gt;&gt;</a>\n"; 
} 
echo "</center>\n"; 
?>

PHP Code:

for ($i=0; $i!=4; $i++) { 
                        echo "\t<td>".$row['name']."</td>\n"; 
                    } 


First, use $i<4 rather than $i!=4. Second, since your inside the same itteration of your master while loop $row['name'] is going to contain the same value for each of your sub-loops itterations until the next time the master loop runs, if that makes sense.

So where should i place the the for loop?

You may want to change your while condition and then your for block:

PHP Code:

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
  if($bgcolor == "#E0E0E0"){
    $bgcolor = "#FFFFFF";
  }else{
    $bgcolor = "#E0E0E0";
  } 
  echo "<tr bgcolor=".$bgcolor.">\n";
  for ($i=0; $i<4; $i++) {
    echo "\t<td>".$row[$i]."</td>\n";
  }
  echo "</tr>\n";
} 


This will loop through each row with the for loop and an array indexed 0-3. Your for loop will then display each entry of that row by referencing those index numbers.

This is great and all but this is what i would like to do, I have an inventory of products to be displayed in a 4x4 table. Everything I have done and everything I have gotten for help shows 4cols with 16 rows. I am pulling out 16 records and then would like to display the records like so:

[1][2][3][4]
[5][6][7][8]
[9][10][11][12]
[13][14][15][16]

Wait, how is your information organized in a database. The code I gave you will = work if it is four columns such as 'product name', 'serial number', 'quantity', and 'price' and then 4 rows of entries. If your information is just 16 rows of products just under the column 'name', do something like this:

PHP Code:


for ($i=0; $i<4; $i++) {
  if($bgcolor == "#E0E0E0"){
    $bgcolor = "#FFFFFF";
  }else{
    $bgcolor = "#E0E0E0";
  } 
  echo "<tr bgcolor=".$bgcolor.">\n";
  for ($j=0; $j<4; $j++) {
    $row = mysql_fetch_assoc($result);
    echo "\t<td>".$row['name']."</td>\n";
  }
  echo "</tr>\n";
} 


Thank you this is almost perfect ... I am only getting 15 of the 16 results to show up in the cells. Any ideas why this is ocurring? It is dropping off the first record that is returned from the query.
==================
Got it this is solved ... i was doing the above code with in my original while statement. All is good now, thanks for all the suggestions!

Try changing your max results to 17