Cool I was able to figure it out the problems.
You had a couple ; left off and the variables needed to be surrounded by { } but I got it to work like this
$totalrows = $oSQL->DBRowCount($DBResource);
// load the result into an array
while ($row = $oSQL->DBFetchArray($DBResource)) {
$result[] = $row;
}
// calculate how many table rows we need to display all results
$rowstoprint = $totalrows / 2 ;
// make a loop to output every html row of the table
for ($i=0;$i < $totalrows /2 ;$i++){
// second counter - calculate the right index for the right column
$j = $i + $rowstoprint;
echo <<< UNSPRINT
<tr>
<td align="center" class="$strColor">
UNSPRINT;
if ( $result[$i]['Email'] != "" ) {
echo <<< UNSPRINT
<font class="medium">
<a href="mailto:{$result[$i]['Email']}">
{$result[$i]['FirstName']}
{$result[$i]['LastName']}
</a>
</font>
UNSPRINT;
} else {
echo <<< UNSPRINT
<font class="medium">
{$result[$i]['FirstName']}
{$result[$i]['LastName']}
</font>
UNSPRINT;
}
echo <<< UNSPRINT
</td>
<td align="center" class="$strColor">
UNSPRINT;
if ( $result[$j]['Email'] != "" ) {
echo <<< UNSPRINT
<font class="medium">
<a href="mailto:{$result[$j]['Email']}">
{$result[$j]['FirstName']}
{$result[$j]['LastName']}
</a>
</font>
UNSPRINT;
} else {
echo <<< UNSPRINT
<font class="medium">
{$result[$j]['FirstName']}
{$result[$j]['LastName']}
</font>
UNSPRINT;
}
echo <<< UNSPRINT
</td>
</tr>
UNSPRINT;
}
Only thing I see though is that my last result on row 1 match's the first result on row 2 So not perfect but close
http://www.masna.org/members.php down the bottom in individual members.