[RESOLVED] How to paginate table to 1/2 records per column

dmacman1962

Hi all,

I am setting up a scrapbook page and we will be adding images all the time.

I have a dynamic table to show the image, link and description but I want to break the columns to automatically show 1/2 the images in the first column, and the other 1/2 (or less if its an odd number of images) in the right column.

Here is my code so far...

<table width="160" border="1" bordercolor="#666666">
<?PHP 
while ($row = mysql_fetch_array($result)) {
		$Name = $row['Name'];
		$URL = $row['URL'];
		$Image = $row['Image'];
		?>
  <tr>
    <td><a href="<?PHP echo ($row['URL']); ?>" title="<?PHP echo ($row['Name']); ?>" target="_blank" class="style1"><img src="<?PHP echo 'Images/' . ($row['Image']) ;?>" border="0"/></a></td>
  </tr>
  <tr><td><?PHP echo ($row['Name']); ?></td></tr>
  <?PHP }?>
</table>

So if I have 7 images in the table, I want 4 in the first column and the remainder in the second.

like this...

1 5
2 6
3 7
4

I see that I need to do something like ...

<table width="120" border="0">
  <tr>
    <td>1</td>
    <td>4</td>
  </tr>
  <tr>
    <td>2</td>
    <td>5</td>
  </tr>
  <tr>
    <td>3</td>
    <td></td>
  </tr>
</table>

Thanks in advance,

Don

bpat1434

[man]mysql_num_rows/man can give you the total number of rows returned... you take this number, divide by two, and ceiling that number. Then, just subtract that from your total rows, and you've got 2 columns!!!

<?php

$num = mysql_num_rows($result);
$left = ceil($num/2); // Get the left column
$right = $num-$left;

//.....

Now, if you have 7 rows returned:
7/2 = 3.5
ceil() rounds up: 4
7-4 = 3

So left = 4, right = 3!!

Now, for displaying purposes, you need to have a counter, and just take that counter and subtract one from it to get the row ID:

<?php

$items = array(); // Get all rows into array
while($row = mysql_fetch_array($result))
{
  $items[] = $row;
}

$i=1;
foreach($items as $item)
{
  $l = $i-1;
  $r = $l+$left; // Get right start number (0+4 = 4... start at row 4 (5th image))
  echo '<tr><td>'.$item[$l]['pic'].'</td><td>'.$item[$r]['pic'].'</td></tr>';
}

Now, it won't work prefectly, but it gets you going....

dmacman1962

Hi bpat,

Thanks for responding.

I follow the counter at the top to get the row quantities.

And I follow, partially, the loop, but I tried this and I replaces 'pic' with 'Image' the field name but I am not sure that's where you where heading with this.

When I do it the way I explained, I get...

Cell - Cell
1 - 'blank'
2 - 'blank'

and so on.

Here is the results from a a print_r...

Array
(
[0] => 11
[ID] => 11
[1] => Description goes here.
[Name] => Description goes here.
[2] => store1.gif
[Image] => store1.gif
[3] =>
[URL] =>
[4] => 11
[Listing] => 11
[5] => 1
[SiteEnabled] => 1
[6] =>
[Misc] =>
)

I know that I am off here, just not sure where. Here is my adaptation of your suggestion in my code...

<? 
$conn = mysql_connect("x", "x", "x") 
  OR DIE (mysql_error());
@mysql_select_db ("abc", $conn) OR DIE (mysql_error());

$sql = "SELECT * FROM x WHERE SiteEnabled = 1 ORDER BY Listing";
$result = @mysql_query($sql, $conn) or die(mysql_error());
$row2 = mysql_query($sql, $conn);

// Define whats left and right for columns
$num = mysql_num_rows($result);
$left = ceil($num/2); // Get the left column
$right = $num-$left;		

//	Set up the array to hold the images	
$items = array(); // Get all rows into array
while($row = mysql_fetch_array($result))
{
  $items[] = $row;
} 	
		?>
<table width="160" border="1" bordercolor="#666666">
<?PHP 
  $i=1;
foreach($items as $item)
{
  $l = $i-1;
  $r = $l+$left; // Get right start number (0+4 = 4... start at row 4 (5th image))
  echo '<tr><td>'.$item[$l]['pic'].'</td><td>'.$item[$r]['pic'].'</td></tr>';
}
?>
</table>
<pre>
<?PHP print_r($item); ?>
</pre>

Thanks,

Don

Weedpacket

Your loop never changes the value of $i, so $l and $r don't change either. Consider using

for($i=0; $i<$left; $i++)
{ 
  $left_item = $items[$i];
  $right_item = $items[$i+$left];
}

instead. 'Course, you may want to check that the last item exists ($items[$left-1+$left]) - it won't if there were an odd number of $items.

I thought I had something lying around here on this subject. If I find it, I'll post it.
Edit: found it. Posted here. More general-purpose than it needs to be.

dmacman1962

Thanks weedpacket,

I did what you suggested and it worked great, of course!

Here is the final working solution.

<?PHP
// Define whats left and right for columns
$num = mysql_num_rows($result);
$left = ceil($num/2); // Get the left column
$right = $num-$left;		

//	Set up the array to hold the images	
$items = array(); // Get all rows into array
while($row = mysql_fetch_array($result))
{
  $items[] = $row;
} 
//now start the table (HTML)	
?>
<table width="160" border="1" bordercolor="#666666">
<?PHP 
for($i=0; $i<$left; $i++)
{
  $left_item = $items[$i];
  $right_item = $items[$i+$left];
//display all the images in table format until there is none left
    echo '<tr><td align="center"><img src="Images/'.$left_item['Image'].'"/></td><td align="center"><img src="Images/'.$right_item['Image'].'"/></td></tr>';
 	echo '<tr><td align="center">'.$left_item['Name'].'</td><td align="center">'.$right_item['Name'].'</td></tr>';
} 
?>

Thanks,

Don

bpat1434

Mistake by me.... forgot that little incrementation part.....