Complex Loops

[RichieVC]

Creating a Complex Loop

I'm create a loop for a database user list to print in a table 3 accorss 10 down.

This will fill a page then when this value is reach (which is 30 Results) then a page break is inserted I have it working with out the database but when I add the data and try to count the rows it does'nt work well.

here is the code minus the page break part
<?
require_once('../../../includes/database.php');

      $res =  db_query("SELECT count(*) as num 
                        FROM user");
      $num = db_result($res, 0,"num");

#this is the area that works
#I try to count the rows form the data base abd replace the row value with the results then page break on every 30 results

// Set the num of rows and cols
$cols = 3;
$rows = 10;

 for ($i = 1; $i <= $rows; $i++) {
  echo "<div class=Section1>
        <table class=NormalTable 
           border=0 
           cellspacing=2 cellpadding=2
           style='border-collapse:collapse;padding-top-alt:0in;padding-bottom-alt: 0in'>";
  echo "<tr style='yfti-irow:0;page-break-inside:avoid;height:1.0in'>"; 
    for ($x = 1; $x <= $cols; $x++) {
    $output = "<td width=252 
                   style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'>
                  <p class=Normal 
                     align=center 
                     style='margin-top:0in;
                            margin-right:5.3pt;
                            margin-bottom:0in;
                            margin-left:5.3pt;
                            margin-bottom:.0001pt;text-align:center'>
                   <span class=SpellE>xxx";

       echo "</span></p></td>";
       echo "$output";       
    } // end for cols
echo "</tr>";

echo "</table></div>";

} // end Rows

?>

If any can help theat would be great been fighting with this for a week

Thanks in advance

[bubblenut]

There are much easier ways of doing this but without seeing how your database functions are working it will be difficult to help.
Bubble

[RichieVC]

These are my basic db function ironiclly was use off this site

function db_connect() {
GLOBAL $sys_dbhost,$sys_dbuser,$sys_dbpasswd;
$conn = mysql_connect($sys_dbhost,$sys_dbuser,$sys_dbpasswd);
if (!$conn) {
echo mysql_error();
}
return $conn;
}

  function db_query($qstring,$print=0) {
         GLOBAL $sys_dbname;
         return @mysql($sys_dbname,$qstring);
  }

almost all db_query & db_results are in this format so if you see db_????? it is the mysql equivallent

but I will continue to work on this.

Thank for you reply

[RichieVC]

I'm soory It just occured to me what you were asking for

I really do not have anything solid for the db functions i guess this is were i'm stuck I just using a basic while loop

again I sorry for that misunderstanding

[mtimdog]

Haven't tested...but this is where you probly should be heading towards....substitute in your db_ functions as you wish....database abstraction is a good thing in the beginning of a project, but when you've chosen your db for good, it just adds overhead to the pages.🙂 🙂

<?
//if using mysql

$res = mysql_query("SELECT * FROM user"); 
if (mysql_num_rows($res) > 0){

// Set the num of rows and cols 
$cols = 0; 
$rows = 0;
$max_cols=3;
$max_rows=10; 
while ($data=mysql_fetch_array($res)){
	if ($rows==0){ //echo out table info
		echo "<div class=Section1> 
<table class=NormalTable 
border=0 
cellspacing=2 cellpadding=2 
style='border-collapse:collapse;padding-top-alt:0in;padding-bottom-alt: 0in'>"; 
	}

if ($cols == 0){ //output the tr
	echo "<tr style='yfti-irow:0;page-break-inside:avoid;height:1.0in'>";
}

echo "<td width=252 
style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'> 
<p class=Normal 
align=center 
style='margin-top:0in; 
margin-right:5.3pt; 
margin-bottom:0in; 
margin-left:5.3pt; 
margin-bottom:.0001pt;text-align:center'> 
<span class=SpellE>xxx"; 
	echo $data[variables to put in???];
	echo "</span></p></td>"; //before, you were outputting the end of the td before the beginning

$cols++;

if ($cols == $max_cols){//reset cols, make new row, output trs
	echo '</tr>';
	$rows++;
	$cols=0;
}

if ($rows == $max_cols){//reset rows, end table,put in line break--I substituted <hr>
	echo '</table></div><br><hr><br>';
	$rows=0;
}		

}//end while loop

//now the tricky part, completing the last table

if ($cols == 0 && $rows == 0){//done
}else{//end cols, then end table

while ($cols !=0 && $cols < $max_cols){//don't do if the cols have been reset
   		echo "<td width=252 
	style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'> 
	<p class=Normal 
	align=center 
	style='margin-top:0in; 
	margin-right:5.3pt; 
	margin-bottom:0in; 
	margin-left:5.3pt; 
	margin-bottom:.0001pt;text-align:center'> 
	<span class=SpellE>xxx</td>";
   		$cols++;
}
if ($cols == $max_cols) echo '</tr>';//to end the row if needed

echo '</table></div>';//to end the table
}//end else


}//end if there are more than 0 rows
?> 

[bubblenut]

<?php
require_once('../../../includes/database.php');

$res = db_query("SELECT * FROM user");
$num = mysql_num_rows($res);
for($i=0;$row=mysql_fetch_row($res);$i++) {
?>
<div class="section1">
    <table class="NormalTable" border="0" cellspacing="2" cellpadding="2" style='border-collapse:collapse;padding-top-alt:0in;padding-bottom-alt: 0in'>
        <tr style='yfti-irow:0;page-break-inside:avoid;height:1.0in'>
<?php
    $row_c=count($row);
    for($j=0;$j<$row_c;$j++) {
?>
            <td width="252" style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'>
                <p class="Normal" align="center" style='margin-top:0in; margin-right:5.3pt; margin-bottom:0in; margin-left:5.3pt; margin-bottom:.0001pt;text-align:center'>
                <span class=SpellE><?=$row[$j]?></span>
                </p>
            </td>
            <?=$row[$j]?>
<?php
    }
?>
        </tr>
    </table>
</div>
<?php
}
?>

Try That
HTH
Bubble

[RichieVC]

YOU ARE THE MAN OR GIRL EITHER WAY YOUR THE BOMB

THANKS A HELL OF A LOT

[mtimdog]

wonder who he was talking to?

[bubblenut]

I've got my money on you mtimdog, and if I loose my money on this one I'll remember not to put my money on RichieVC (read: I didn't read the question very well and as a result mine doesn't even do what's expected of it :o )
Bubble