Horizontal looping question

smith15

I need to be able to do display data results like so:

namefield name1 name2 name3
addrfield addr1 addr2 addr3
cityfield city1 city2 city3

And then say after 3 result columns, it starts over on a new line repeats the field names and next set of data:

namefield name4 name5 name6
addrfield addr4 addr5 addr6
cityfield city4 city5 city6

Until all the records in the resultset have been displayed. Does that make sense? I'm stuck on this one and have been playing with all sorts of code for hours now.

I came close with this set of code:


$sql="SELECT * FROM mytable order by myrecordnumber "; 
$RS=mysql_query($sql); 


$result = mysql_query($sql);  

$i = 0;  

?><table>  

  <tr>  

<? while($row = mysql_fetch_object($result)) { ?>  

    <td><?=$row->myrecordnumber?></td>  

<? $i++ ?>  

<? if($i % 3 === 0) { ?>  

  </tr>  

  <tr>  

<? } ?>  

<? } ?>  

</table>

Which outputs:
2 4 6
7 8 9
14 15 16

which is great but I need to show more than one field like I demonstrate above (name, address, city, etc) and doing a <tr> messed it all up. Also, I couldn't figure out how to get a table in front of all this to show the data fieldnames (namefield, addrfield, city, etc).

Any tips or advice on how to solve this would be greatly appreciated. Thank you!

perrohunter

ur code is littel messy :S

ill rewrite it a lil bit.

What i think that whould be possible would be a multiloop 😛

i just made that up XD, i use em too 😛 , the idea is to pull the results on a loop

then every 3 results as u want, the loop will start another loop that ejects the next 3 loops, i might ask how the hell the next subloop will know where to start from ?

after doing the first loop try sending on which record the previous loop stopped.

lemme see if this works :S


<?php

 $sql="SELECT * FROM mytable order by myrecordnumber ";
$RS=mysql_query($sql);


$result = mysql_query($sql);  

$i = 0;  

$subcounter = 0;

echo "<table>  

  <tr>  ";
while($row = mysql_fetch_object($result)) { 
echo "<td>$row['myrecordnumber']</td> ";
 $i++
if($i % 3 === 0) { 

$query2 = "SELECT * FROM thetable ORDER BY numberagain LIMIT $subcounter , 3";
$result2= mysql_query($query2);

while($row = mysql_fetch_object($result)) { 
echo "<td>$row['myrecordnumber']</td> ";
 $subcounter++

}
}

 }   

 }   

echo "</table> ";

and so on , i hope u get the idea 😃 😃 😃

smith15

I think but I'm not sure that solves my problem. Right now I get the output in a table correctly as:

2 4 6
7 8 9
14 15 16

But I want to modify it to be:

recordnum 2 4 6
name john joe susan
city city2 city4 city6

then since it showed 3 columns now, start a new table/row below as:

recordnum 7 8 9
name john2 jim alex
city city7 city8 city9

and continue to do that until it lists all records.

I can't figure out how to get the table/cells with the field names to loop through as well and show multiple rows in each column for each record.

Probably a table within table type of mess.

I'm either making this too difficult or it really is that hard 🙂

bradgrafelman

To jump in and offer an alternative, you could store the results in different variables for each row, and then echo the variables after you're done, like so:

<?PHP
$query = 'SELECT `namefield`, `addrfield`, `cityfield` FROM `mytable` ORDER BY `myrecordnumber`'; 
$exec = mysql_query($query);
$row_name = $row_addr = $row_city = NULL;

while($result = mysql_fetch_assoc($exec)) {
    $row_name .= $result['namefield'] . ' ';
    $row_addr .= $result['addrfield'] . ' ';
    $row_city .= $result['cityfield'] . ' ';
}

?>
<table>
  <tr>
    <td>namefield</td>
    <td><?PHP echo rtrim($row_name); ?></td>
  </tr>
  <tr>
    <td>addrfield</td>
    <td><?PHP echo rtrim($row_addr); ?></td>
  </tr>
  <tr>
    <td>cityfield</td>
    <td><?PHP echo rtrim($row_city); ?></td>
  </tr>
</table>

(My example assumed you wanted one cell as a header cell, and then one cell with all of the data, using spaces in between. You can easily modify this to make each result returned displayed in its own separate cell in each row.)

EDIT: Oops! Read too quickly - didn't see the part about splitting after 3 results. Though, looking above, an example was giving using the modulus (spelling?) operator, which is the easiest way.

smith15

bradgrafelman wrote:
To jump in and offer an alternative, you could store the results in different variables for each row, and then echo the variables after you're done, like so:
<?PHP
$query = 'SELECT `namefield`, `addrfield`, `cityfield` FROM `mytable` ORDER BY `myrecordnumber`'; 
$exec = mysql_query($query);
$row_name = $row_addr = $row_city = NULL;

while($result = mysql_fetch_assoc($exec)) {
    $row_name .= $result['namefield'] . ' ';
    $row_addr .= $result['addrfield'] . ' ';
    $row_city .= $result['cityfield'] . ' ';
}

?>
<table>
  <tr>
    <td>namefield</td>
    <td><?PHP echo rtrim($row_name); ?></td>
  </tr>
  <tr>
    <td>addrfield</td>
    <td><?PHP echo rtrim($row_addr); ?></td>
  </tr>
  <tr>
    <td>cityfield</td>
    <td><?PHP echo rtrim($row_city); ?></td>
  </tr>
</table>
(My example assumed you wanted one cell as a header cell, and then one cell with all of the data, using spaces in between. You can easily modify this to make each result returned displayed in its own separate cell in each row.)

EDIT: Oops! Read too quickly - didn't see the part about splitting after 3 results. Though, looking above, an example was giving using the modulus (spelling?) operator, which is the easiest way.

oh man we're getting close.... if I change this section to include TD tags instead of spaces I get the table layout I'm after:

while($result = mysql_fetch_assoc($exec)) {
$row_name .= $result['namefield'] . '</td><td>';
$row_addr .= $result['addrfield'] . '</td><td>';
$row_city .= $result['cityfield'] . '</td><td>';
}

But I'm not sure how to tackle the show 3 columns then repeat type of functionality.

I almost have to run the while until it hits 3, dump the table, then do it again.... hmmmmm

EDIT: I think I got it to work... i just have to clear the variables after 3 and run through again. however, there are about 100 variables. Is there an easier way to set and clear them besides:

$row_name = $row_addr = $row_city = NULL;

and

$row_name .= $result['namefield'] . '</td><td>';
$row_addr .= $result['addrfield'] . '</td><td>';
$row_city .= $result['cityfield'] . '</td><td>';

bradgrafelman

Humm... well, not really. That's probably the easiest way to go about it.

smith15

bradgrafelman wrote:
Humm... well, not really. That's probably the easiest way to go about it.

Darn.... I remember doing something with for/each to set and display a bunch of field names and values in another script... I'm thinking it'd be something like that?

this time I'd use for each to set each table field title, field value, and then set all field values to NULL... repeat.

😕

bradgrafelman

[man]Foreach[/man] loops through an array, one value at a time.

EDIT: I guess what you could do is set up an array, such as:

$fields = array();

while($result = mysql_fet_assoc($exec) {
  $fields['city'] = $result['city'];
  $fields['state'] = $result['state'];
}

etc., and then when you're at the end of the 3rd loop and want to clear everything, just do:

$fields = array();

smith15

bradgrafelman wrote:
[man]Foreach[/man] loops through an array, one value at a time.

I can't remember how I did it, but remember doing something like that... might not have been for/each.

I'll see if I can find it.

Thank you for the help and getting me going in the right direction finally!!! 😉

EDIT: ok that might work!

bradgrafelman

I edited my post above, make sure you read the edit 😉