Somewhat Complicated PHP question

[ow-phil]

Hi All,

I am working on a set of PHP files for displaying data for timetables and schedules. I am having a problem with one specific item. First have a look at the link to the page, which will give you some idea of the layout of the table.

http://www.ontarioeastern.com/viewett.php?subdivision=Prescott

Now the problem I am having is in the field called "signal". What I want to do is to have a "rowspan" for the table data "TD", when more than one of the same type of signal is listed in order. Example

How it looks now:

4.9 Preswood CTC

7.2 Uplands CTC

12.0 Manotick CTC

20.3 Osgoode OCS

28.5 Kemptville OCS

How I want it to look:

4.9 Preswood |

---------------------|
7.2 Uplands | CTC
---------------------|

12.0 Manotick |

20.3 Osgoode |
---------------------|

28.5 Kemptville | OCS

The thing is I have absolutely no clue on how to get it to do this? Does anyone have any ideas?

Below is the source code for what I am doing.

Thanks in advance...

Phil

SOURCE CODE HERE.

<?
{
$dbquery = "select from submaster where subdivision = \"$subdivision\" and activestatus = \"active\" ";
$result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();}
if($row = mysql_fetch_array($result))
{
$subdivisionname=$row[subdivision];
$subdivisiondescription=$row[description];
$subdivisionnotes=$row[notes];
$subdivisionmap=$row[categorypicture1];
?>
<table cellpadding=0 cellspacing=0 border=1 bordercolor=black align=center>
<tr><td colspan=3 align=left><? echo $subdivisionname ?></td></tr>
<tr><td valign=top><table cellpadding=0 cellspacing=1 border=1 bordercolor=black align=center><?
$dbquery = "select from subdivision where subdivision = \"$subdivisionname\" and activestatus = \"active\" order by mile ";
$result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();}
while($rowstations = mysql_fetch_array($result))
{
echo "<tr><td align=center>$rowstations[mile]</td><td align=center>$rowstations[station]<br><font size=1>$rowstations[notes]</td><td align=center>";

if($rowstations[siding]!="") { echo "$rowstations[siding]"; } else { echo "-"; } echo "</td><td>$rowstations[signal]</td></tr>";
}
}
?></table>
</td>
<td valign=top><? echo $subdivisiondescription ?></td>
<td valign=top><img src="images/products/<? echo $row[categorypicture1] ?>"></td>
</tr>
</table>
<? } ?>

[twilson]

Phil,

Here is a possible solution:

<?php
$master_query = "SELECT * FROM submaster WHERE subdivision='$subdivision' AND activestatus='active'"; 
$master_result = mysql_db_query($dbname,$master_query);
if (mysql_error() != "") {
  echo mysql_error();
} 

$Data = mysql_fetch_array($master_result);
?> 
<table cellpadding=0 cellspacing=0 border=1 bordercolor=black align=center> 
  <tr>
    <td colspan=3 align=left>
      <? echo $Data[subdivision]; ?>
    </td>
  </tr> 
  <tr>
    <td valign=top>
      <table cellpadding=0 cellspacing=1 border=1 bordercolor=black align=center>
<?php
$signal_query = "SELECT DISTINCT signal FROM subdivision WHERE subdivision='$Data[subdivision]' AND activestatus='active' ORDER BY mile";
$signal_result = mysql_db_query($dbname,$result_query);

while (list($Signal) = mysql_fetch_row($signal_result)) {
  $result_query = "SELECT * FROM subdivision WHERE subdivision='$Data[subdivision]' AND signal='$Signal' AND activestatus='active' ORDER BY mile";
  $result = mysql_db_query($dbname,$result_query);
	if (mysql_error() != "") {
	  echo mysql_error();
	} 

$Num_Stations = mysql_num_rows($result);

  $I = 1;
  while($Stations = mysql_fetch_array($result)) { 
    echo "
      <tr>
        <td align=center>
          $Stations[mile]
        </td>
        <td align=center>
          $Stations[station]
          <br><font size=1>$Stations[notes]
        </td>
        <td align=center>"; 

    if ($Stations[siding]) {
      echo "$Stations[siding]";
    } else { 
      echo "-";
    }

    echo "
    </td>";
if ($I == '1') {
    echo "
    <td ROWSPAN=$Num_Stations>
      $rowstations[signal]
    </td>";
}
echo "</tr>"; 

$I++;
  } 
} 
?>
</table> 
</td> 
<td valign=top><?php echo $Data[description]; ?></td> 
<td valign=top><img src="images/products/<?php echo $Data[categorypicture1]; ?>"></td> 
</tr> 
</table>

Let me know how it goes,
Tom

[ow-phil]

I tried the solution presented and have run into the following error

Fatal error: Call to undefined function: _mysql_fetch_array() in /web5/www.ontarioeastern.com/viewett2.php on line 60

If you go to http://www.ontarioeastern.com/viewett2.php you will see where it comes up. It does not like the array for the $Data field.

Phil

[twilson]

Phil,

I don't see any errors coming up right now...

I use $Data a lot with that function so it should be fine, there's an extra _ in the error before the function name for some reason that may have been a problem...

undefined function: _mysql_fetch_array() in /web5/www

Let me know how it goes,
Tom 🆒

[ow-phil]

An errant ASCII code got in there with the underscore and it has been corrected, however if you goto the page: http://www.ontarioeastern.com/viewett2.php?subdivision=Prescott

You can see the result. It is displaying info but not all and the table is off.

Phil