How could I loop through this data, yet not flip to another row after every recordset?

for( ... ) 
   echo "<tr>";
   // cell logic here
   echo "</tr>";
}

Select allOpen in new window

define('NCOLS', 84);
$body = '<tr>';
// KEEP TRACK OF WHAT ROW WE ARE ON
$current_row = 0;
$col = 0;

foreach ($results as $row) {
  // WE NEED TO START ANOTHER ROW
  if ($current_row != $row['row_number']) {
    if ($current_row != 0) {
      // FINISH OFF THE ROW;
      while($col++ < NCOLS) {
        $body .= '<td></td>';
      }
      $body .= '</tr><tr>';
    }
    // MOVE OUR ROW MARKER
    $current_row = $row['row_number'];

    // RESET COL COUNT
    $col = 0;
    // TODO: HANDLE MISSED ROWS HERE
  }
  
  // HERE WE SHOULD BE GOOD TO GO WITH OUTPUT OF CELLS
  // LOOP THROUGH BLANKS
  while($col++ < $row['start_cell']) {
    $body .= '<td></td>';
  }
  
  // HERE IS WHERE WE OUTPUT OUR DATA
  $body .= "<td>{$row['title']}</td>";
  
  // NOTHING MORE TO DO THE NEXT ITERATION WILL DO THE WORK
}
// LASTLY WE FINISH OF THE LAST ROW AND CLOSE IT
while($col++ < NCOLS) {
   $body .= '<td></td>';
}
$body .= '</tr>';

Select allOpen in new window

<?php
//ERROR REPORTING
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(E_ALL); 
require_once('projectpageclass.php');
require_once('model_class.php');

$new_page= new ProjectPage;
$page_title="South Area Network Development Project List";
$new_date=new DateCalc;

$current_row="";

if(!isset($_GET['year']))
{
	$this_year=date("Y");
}
else
{
	$this_year=$_GET['year'];
}
$the_date=$this_year;
$the_date.="-01-01";

$year_one_calc = date('c', strtotime("$the_date - 1 year"));
$year_one=date("Y", strtotime($year_one_calc)); 

$year_two=$this_year;

$year_three_calc = date('c', strtotime("$the_date + 1 year"));
$year_three=date("Y", strtotime($year_three_calc)); 

$dayNumber = date("z") + 1; 

include('mssql_db_cred.php');

$mssql_pdo = new PDO("dblib:host=".$mssql_cred_data['server'].";dbname=".$mssql_cred_data['dbname'],$mssql_cred_data['user'],$mssql_cred_data['pw']); 
$mssql_pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
if(!$mssql_pdo)
{
	echo "no connection";
}

include("gant_header.php");

//here's the sql that gives you all of your content

//this is putting the dates that are being displayed on the calendar into a code friendly format
$day = date('w');
$week_start = date('c', strtotime('-'.$day.' days'));
$this_week = date('c', strtotime($week_start));

/*$week_one_data = date('c', strtotime("$this_week - 6 weeks"));
$week_one=date("m/d/Y", strtotime($week_one_data));

$week_twelve_data = date('c', strtotime("$this_week + 5 weeks"));
$week_twelve=date("m/d/Y", strtotime($week_twelve_data));*/

//I used this next chunk of code to test for the "sound-ness" of my code in that there wasn't any data between September and December of this year
//$week_one= date("m/d/Y", strtotime("-10 months"));
//echo $week_one;
//$week_twelve= date("m/d/Y", strtotime("-6 months"));
//echo $week_twelve;

$week_one='01/01/2015';
$week_twelve='05/31/2015';

$query = "EXECUTE stp_Select_REPORT_DevelopeProjects_Gantt :DataDisplay_Start, :DataDisplay_End";
$stpro = $mssql_pdo->prepare($query);
$stpro->bindParam(':DataDisplay_Start', $week_one, PDO::PARAM_STR);
$stpro->bindParam(':DataDisplay_End', $week_twelve, PDO::PARAM_STR);

// call the stored procedure
$stpro->execute();

$results = $stpro->fetchALL(PDO::FETCH_ASSOC);

/*
$number=1;
foreach($results as $row)
{
	echo $number.') '.$row['str_ProjectName'].' | '.$row['dte_DateStarted'].'<br>';
	$number=$number+1;
}
*/

$start_row=0;
$new_row=0;


$current_row_number=1;
$col=0;
$number_cols=84;
$number=1;

$body.="<tr>";

/*this is golden - this is your template, right here
foreach($results as $row)
{
	if($current_row_number<>$row['DataDisplay_Row'])
	{
		$body.="</tr><tr>";
	}
	$body.="<td>";
	$body.=$row['DataDisplay_Row'];
	$body.="</td>";
	$current_row_number=$row['DataDisplay_Row'];
}
*/	

foreach($results as $row)
{
	if($current_row_number<>$row['DataDisplay_Row'])
	{
		$body.="</tr><tr>";
	}


	$body.="<td>";
	if($row['DataDisplay_EndCell']=="" OR $row['DataDisplay_EndCell']<0)
	{
		continue;
	}
		if($row['DataDisplay_StartCell']=="")
		{
			$the_cell=$row['DataDisplay_EndCell'];
		}
		else
		{
			$the_cell=$row['DataDisplay_StartCell'];
		}
	$body.=$the_cell;
	$body.="</td>";
	
	$current_row_number=$row['DataDisplay_Row'];
}	
$body.="
	<!-- this last row is just for aesthetics so there's a little room at the bottom of the page. It also gurantees a certain with for all of the \"daily\" cells -->";
	include("spacer_single.php");
	$body.="
</table><br><br>";
		
$new_page->setBody($body);

echo $new_page->display();

?>

Select allOpen in new window