Code: Select all
Parse error: parse error, unexpected $ in /home/lfeandy/public_html/boatbase/proto/pages/boatprep.php on line 68Code: Select all
<?php
//reset variables
$pageoutput = "";
$tablerows = "";
if(isset($_COOKIE['SID'])) {
$sid = addslashes($_COOKIE['SID']);
$count = mysql_fetch_array(mysql_query("SELECT COUNT(*) as thenumber FROM bb_sessions WHERE SessionID = '$sid'"));
if($count['thenumber'] !== 0) {
$tablesession = mysql_fetch_assoc(mysql_query("SELECT * FROM bb_sessions WHERE SessionID = '$sid'"));
$userid = $tablesession['UserID'];
$tableteam = mysql_fetch_assoc(mysql_query("SELECT * FROM bb_team WHERE HelmID = '$userid' OR CrewID = '$userid'"));
$tid = $tableteam['TeamID'];
$result = mysql_query("SELECT * FROM bb_boatprep WHERE TeamID = '$tid'");
while ($row = mysql_fetch_assoc($result)) {
$userid = $row['UserID'];
$username = mysql_fetch_assoc(mysql_query("SELECT * FROM bb_users WHERE UserID = '$userid'"));
$tablerows.=<<<TROWS
<tr>
<td>{$row['JobDate']}</td><td>{$username['UserName']}</td><td>{$row['JobDescription']}</td>
</tr>
TROWS;
}
//create output
$pageoutput.=<<<POUT
<p><strong>Boat Prep Page</strong></p>
<p>Things to do:</p>
<p>
<table border="1">
<tr>
<td>Date Required:</td><td>Added by:</td><td>Job Description:</td>
</tr>
{$tablerows}
</table>
</p>
<p>
[<a href="index.php?pid={$pid}&action=add">Add Item</a>]
[<a href="index.php?pid={$pid}&action=edit">Edit Item</a>]
[<a href="index.php?pid={$pid}&action=remove">Remove Item</a>]
<p>Help to keep this site free, if you need any items to help you complete a job. Click <a
href="index.php?pid=8">here</a></p>
POUT;
} else {
$pageoutput = "Please Login";
}
?>