include_once("~SBconnect.php"); if (isset($_GET["id"])) { $id = $_GET["id"]; } // extract data $querysb = "SELECT * FROM sbdiagrams WHERE id = $id"; $resultsb = mysqli_query($linksb, $querysb); if ($resultsb) { while ($row=mysqli_fetch_assoc ($resultsb)) { $id = $row["id"]; $rlyco = $row["rlyco"]; $boxname = $row["boxname"]; $plandate = $row["plandate"]; $siteurl = $row["siteurl"]; $planby = $row["planby"]; $photo = $row["photo"]; $relatedurl = $row["relatedurl"]; $comments = $row["comments"]; $updated = $row["updated"]; $boxnamedisplay = stripslashes($boxname); } $queryco = "SELECT * FROM rlyco"; $resultco = mysqli_query($linksb, $queryco); if ($resultco) { while ($row=mysqli_fetch_assoc ($resultco)) { $id = $row["id"]; $abbrev = $row["abbrev"]; $company = $row["company"]; if ($rlyco == $abbrev) { $fullco = $company; } } if (!$planby) { $planby = "John Hinson"; } } } ?>
A photograph of the signal box track diagram for print $boxname ?> ( print $fullco ?> Railway) box if ($plandate) echo " at " . $plandate ?>, by print $planby ?>.
A drawing of the signal box track layout for print $boxname ?> ( print $fullco ?> Railway) box if ($plandate) echo " at " . $plandate ?>, from the collection of print $planby ?>.
Further information about print $boxname ?> box (opens in new tab/window).
} ?>