[FX.php List] Split results into two columns

Gjermund Gusland Thorsen ggt667 at gmail.com
Fri Aug 28 01:38:03 MDT 2009


Does the output validate?

ggt

2009/8/28 Stephe Pocock <zippyaus at yahoo.com>:
> Hi and thanks for the feedback
>
> I was able to achieve the following using the code (thanks to FMWebschool).
>
> http://pastebin.com/m7794b15e
>
> <?php
> $cols = 2;   // Change value for any number of columns
> $cell = 0;
> foreach($catResult['data']as $key=>$catData){
> if( ($cell % $cols) == 0 ) { echo "<tr>\n"; }
> ?>
>     <td height="42"><img src="<?php echo $catData['PhotoURL'][0];?>"
> width="120"></td>
>     <td><?php echo $catData['Full Name'][0];?><br>
>       <?php echo $catData['UserName'][0];?><br>
>       <?php echo $catData['Export Title'][0];?><br>
>       <?php echo $catData['Level Number'][0];?> <?php echo $catData['Calc
> Group Short'][0];?></td>
> <?php
> if( (($cell+1) % $cols) == 0 ) { echo "</tr>\n"; }
> $cell++;
> } ?>
>
> Hope this helps someone.
>
> Cheers
>
> ________________________________
> From: Jonathan Schwartz <jschwartz at exit445.com>
> To: FX.php Discussion List <fx.php_list at mail.iviking.org>
> Sent: Thursday, 27 August, 2009 10:17:45 PM
> Subject: Re: [FX.php List] Split results into two columns
>
> I think the key (no pun) is to create the content first and then display
> when done.
> How about this:
> Option 1:
> Process the found set with the standard foreach(), test for odd/even
> records, build the even and odd record tables first and then display them
> after they are complete.
> Option 2:
> Process the found set with a for(), alternating left and right columns by
> testing for even/odd $key, building them first and then displaying, as
> above.
> This is just the broad stroke.
> J
>
> Hi all
>
> I have a confession to make.  I use this code alot, but I don't actually
> understand how it works.
>
> http://pastebin.com/m7cb20894
>
> <?php
> $i=0;
> $half = (int) ($catResult['foundCount']/2 + 0.5);
>
> foreach ($catResult['data'] as $key => $catData)
> {
> if($i == $half && $i > 10)
> {
> ?>
>             </table>
>       <td valign="top">
>             <table border="1">
> <?php
> }
>
> ?>
>     <tr>
>         <td>
>             <img src="<?php echo $catData['PhotoURL'][0];?>"
> width="120"></td>
>         <td><?php echo $catData['Full Name'][0];?><br>
>         <?php echo $catData['UserName'][0];?><br>
>         <?php echo $catData['Export Title'][0];?><br>
>         <?php echo $catData['Level Number'][0];?> <?php echo $catData['Calc
> Group Short'][0];?>
>         </td>
>
>     </tr>
> <?php
> $i++;
> }
> }
> ?>
>
>
>
> The result is half the found set is in one table row that the other half in
> another.
>
> This works well in most situations, but I have a photobook where I want two
> columns but I would like the odd records in the left and the even records in
> the right so that the photo book flows with all the A's then all the B's etc
>
> Does this make sense?  Is what I want possible?
>
> Thanks in advance
>
> Stephen
>
> start: 0000-00-00 end: 0000-00-00
>
> ________________________________
>
> Find local businesses and services in your area with Yahoo!7 Local. Get
> started.
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> --
>
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> ________________________________
> Find local businesses and services in your area with Yahoo!7 Local. Get
> started.
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>


More information about the FX.php_List mailing list