Breaking up MySQL results with PHP

[skyer2000]

I have the following MySQL query

 

SELECT * FROM table ORDER BY formtimestamp

 

There are about 10-20 rows that have the same formtimestamp, and I want those to be seperated visually form the other formtimestamps (with new lists). However, when this pulls in results, everything is clumped together.

 

Is there a way in PHP that will make a break when the formtimestamp changes?

[p2grace]

I'd just do a check while you're looping through the results.  Save the current timestamp into a variable and then on the next iteration check to see if the current timestamp is the same as the variable from the prior, if it isn't do a break.

[rhodesa]

the code would look like...

 

<?php
  $sql = "SELECT * FROM table ORDER BY formtimestamp";
  $result = mysql_query($sql);
  $last = null;
  while($row = mysql_fetch_assoc($row)){
    if($last && $row['formtimestamp'] != $last){
      print "<hr>"; //Do break stuff here
      $last = $row['formtimestamp'];
    }
    //print $row stuff here
  }
?>

[p2grace]

Yeup exactly.

[skyer2000]

Why didn't I think of that haha, thanks for the help!