Query Results as links... Next step?

[brandonpturner]

After literally days of searching for a solution, I found a thread on this site talking about exactly what I need. There's a problem, though. I need a next step. I found how to turn a query results into a link to a specific page, based on the contractorid, but now I need to know how to populate a table on that page with his information, only. This is what I have on the first page:

echo "<td class='cell_client_left' align='center'>";
	echo '<a href="week.php?contractorid='.$contractorid.'">' .$fname. "" .$lname. '</a>';
echo "</td>";

Now, when I click on a result, the address bar populates with the correct contractorID which is AWESOME, but... This is my second page:

<?PHP
session_start();
if( $_SESSION['login_type'] != "Client" ) header("Location:./errors/notclient.php"); 

//Troubleshooting
//include_once( "./includes/checksupers.php" );

//Require DB connect info
require_once( "./templates/header.php" );
require_once( "./includes/config.php" );

if ( $client_id == 3 ) $client_id = 14;
$sort = $_POST['sort'];
$clientid = $_SESSION['client_id'];


if( $sort == NULL )
{
	$client_display_timecards_sql = 
		"SELECT  Contractor.ContractorFName,
				 Contractor.ContractorLName,
				 TimeCards.ContractorID,
				 TimeCards.Week,
				 TimeCards.PO,
				 TimeCards.TimeCardDate,
				 TimeCards.TimeCardID,
				 TimeCards.TimeIn,
				 TimeCards.BreakBegin,
				 TimeCards.BreakEnd,
				 TimeCards.TimeOut,
				 TimeCards.HoursTotal,
				 TimeCards.WorkDescription
		FROM Contractor 
		JOIN TimeCards
		ON Contractor.ContractorID = TimeCards.ContractorID
		WHERE TimeCards.ClientID = $clientid
		AND TimeCards.Approved = 0";



$res_client_display_timecards = mysql_query( $client_display_timecards_sql )
or die( "Could not do client display cards query: " . mysql_error() );

echo <<<END
<span class="bold">Time Entry Details: </span>
<br /><br />
<div class="board" id="board_week_timecards">
	<form action="week.php" method="post">
	<div id="list_week_timecards">
		<table id="table_week_timecards">
			<tr>
				<td class="head_client_left" align="center">PO #</td>
		    	<td class="head_client" align="center">Date</td>
		    	<td class="head_client" align="center">Time In</td>
		    	<td class="head_client" align="center">Break Begin</td>
		    	<td class="head_client" align="center">Break End</td>
		    	<td class="head_client" align="center">Time Out</td>
		    	<td class="head_client_right" align="center">Hours</td>
		 	</tr>

END;

$x = 0;	
while( $client_display_timecards = mysql_fetch_assoc( $res_client_display_timecards ) )
{
	$lname = $client_display_timecards['ContractorLName'];
	$fname = $client_display_timecards['ContractorFName'];
	$contractorid = $client_display_timecards['ContractorID'];
	$week = $client_display_timecards['Week'];
	$po = $client_display_timecards['PO'];
	$timecarddate = $client_display_timecards['TimeCardDate'];
	$timecardid = $client_display_timecards['TimeCardID'];
	$timein = $client_display_timecards['TimeIn'];
	$breakbegin = $client_display_timecards['BreakBegin'];
	$breakend = $client_display_timecards['BreakEnd'];
	$timeout = $client_display_timecards['TimeOut'];
	$hourstotal = $client_display_timecards['HoursTotal'];
	$workdescription = $client_display_timecards['WorkDescription'];
	$current_cards[$x] = array(
	'contractorfname' => "$fname",
	'contractorlname' => "$lname",
	'week' => "$week",
	'po' => "$po",
	'timecarddate' => "$timecarddate",
	'timecardid' => "$timecardid",
	'timein' => "$timein",
	'breakbegin' => "$breakbegin",
	'breakend' => "$breakend",
	'timeout' => "$timeout",
	'hourstotal' => "$hourstotal",
	'workdescription' => "$workdescription"
	);


echo <<<END
		  <tr>
		  	<td class="cell_client_left" align="center">$po</td>
		        <td class="cell_client" align="center">$timecarddate</td>
		        <td class="cell_client" align="center">$timein</td>
		        <td class="cell_client" align="center">$breakbegin</td>
		        <td class="cell_client" align="center">$breakend</td>
		        <td class="cell_client" align="center">$timeout</td>
		        <td class="cell_client_right" align="center">$hourstotal</td>
		  </tr>
		  <tr>
		  	<td class="description_left" align="center"> </td>
		  	<td class="description_right" colspan="7">$workdescription</td>
		  </tr>

END;
		++$x;
	}
	echo "

	</table>
</div>
</form>
</div>";

}
?>

What do I need to do to make this table show ONLY entries from the contractorID provided from the first page?

[bradgrafelman]

What have you tried? It seems to be as simple as adding another condition to your WHERE clause to check if the contractor ID matches the one passed in via the query string.

[cretaceous]

looks like you are not accessing the contractorid value in the script

you need to add this near top of script:
$contractorid = $_GET['contractorid '];

then in the sql you need to add this in the WHERE part:

 WHERE TimeCards.ClientID = $clientid
AND TimeCards.Approved = 0
AND Contractor.ContractorID=$contractorid

not sure if you need to have all those WHERE conditions but something like that

[bradgrafelman]

Also note that the above code (as well as your own code) is vulnerable to SQL injection attacks since the user-supplied data was not sanitized before being placed into a SQL query string.

[brandonpturner]

cretaceous;10995037 wrote:

looks like you are not accessing the contractorid value in the script

you need to add this near top of script:
$contractorid = $_GET['contractorid '];

then in the sql you need to add this in the WHERE part:

 WHERE TimeCards.ClientID = $clientid
AND TimeCards.Approved = 0
AND Contractor.ContractorID=$contractorid

not sure if you need to have all those WHERE conditions but something like that

So, I added in the code you gave me. The second page gave me a SQL error. I removed the code you gave me, and now it works? Confused as hell! Ha. Oh well, I guess with works for now. Thank you for your help.

[brandonpturner]

bradgrafelman;10995038 wrote:

Also note that the above code (as well as your own code) is vulnerable to SQL injection attacks since the user-supplied data was not sanitized before being placed into a SQL query string.

Ohhh yes. I am aware. We have not gotten to security yet. I mean, the logout button is just a link to index. Haha.

[brandonpturner]

cretaceous;10995037 wrote:

looks like you are not accessing the contractorid value in the script

you need to add this near top of script:
$contractorid = $_GET['contractorid '];

then in the sql you need to add this in the WHERE part:

 WHERE TimeCards.ClientID = $clientid
AND TimeCards.Approved = 0
AND Contractor.ContractorID=$contractorid

not sure if you need to have all those WHERE conditions but something like that

Alright, now I'm not so sure. Right now, I'm having a problem where the bottom row of the HTML table is combining two contractors into the same $fname $lname. The contractorID is there for only one contractor, and the hours for both are added into him. :/

[cretaceous]

show us your new SQL query - all of it

[brandonpturner]

cretaceous;10995046 wrote:

show us your new SQL query - all of it

Ok. This is the first page. There's a lot going on so bare with me...

$client_id = $_SESSION['client_id'];
//if ( $client_id == 3 ) $client_id = 14;

$sort = $_POST['sort'];

$clientid = $_SESSION['client_id'];

if( $sort == NULL )
{
	$client_display_timecards_sql = 
		"SELECT  Contractor.ContractorFName,
				 Contractor.ContractorLName,
				 TimeCards.ContractorID,
				 TimeCards.WeekEndDate,
				 TimeCards.PO,
				 SUM(TimeCards.HoursTotal)
		FROM Contractor 
		JOIN TimeCards
		ON Contractor.ContractorID = TimeCards.ContractorID
		WHERE TimeCards.ClientID = $clientid
		AND TimeCards.Approved = 0
		GROUP BY TimeCards.WeekEndDate";



$res_client_display_timecards = mysql_query( $client_display_timecards_sql )
or die( "Could not do client display cards query: " . mysql_error() );


// Header Navigation ======================================================================================================
echo <<<END
	<div id="navigation">
		<input name="Submit" type="submit" id="butt_nav_logout" value="" onclick="location.href='index.php';" />
		<input name="Submit" type="submit" id="butt_nav_help" value="" onclick="location.href='help_client.php';" />
		<input name="Submit" type="submit" id="butt_nav_contractors" value="" onclick="location.href='client_contractors.php';" />
	</div>
END;


echo "<div class='content'>";
// Board: Unapproved Timecards ======================================================================================================
echo <<<END
<span class="bold">Unapproved Timecards: </span>
<br /><br />
<div class="board" id="board_client_timecards">
	<div id="list_client_timecards">
	<form action="client.php" method="post">	
		<table id="table_client_timecards">
			<tr>
		    	<td class="head_client_left" align="center">Contractor Name</td>
		    	<td class="head_client" align="center">Week Ending</td>
		    	<td class="head_client" align="center">Total Hours</td>
		    	<td class="head_client_right" align="center">Approve</td>
		  	</tr>

END;

//Loop through rows in query to display selected timecards
	$x = 0;	
	while( $client_display_timecards = mysql_fetch_assoc( $res_client_display_timecards ) )
	{
		$lname = $client_display_timecards['ContractorLName'];
		$fname = $client_display_timecards['ContractorFName'];					//place array values into local vars for easier use in form
		$contractorid = $client_display_timecards['ContractorID'];
		$totalhours = $client_display_timecards['SUM(TimeCards.HoursTotal)'];
		$weekenddate = $client_display_timecards['WeekEndDate'];


//Build an array while displaying rows so correct row can  be marked approved in DB		
		$current_cards[$x] = array(
		'contractorfname' => "$fname",
		'contractorlname' => "$lname",
		'contractorid' => "$contractorid",
		'weekenddate' => "$weekenddate"
		); //echo "<br/><pre>";print_r( $current_cards );echo "</pre><br/>";

//display data each grouped timecard in table using the loop number as reference to the built array for approval of correct row	


echo "<tr>";
	echo "<td class='cell_client_left' align='center'>";
		echo '<a href="week.php?contractorid='.$contractorid.'">' .$fname. " " .$lname. '</a>';
	echo "</td>";

echo <<<END
		    <td class="cell_client" align="center">$weekenddate</td>  

		    <td class="cell_client" align="center">$totalhours</td>
		    <td class="cell_client_right" align="center">
		    	<input type="checkbox" name="approve$x" value="$x" />
		  	</td>

	  </tr>
END;
		++$x;
	}
	echo "
		</table>

</div>
<input id='butt_client_approve' type='submit' name='marked' value='Approve' />
</form>
</div>
</div>
";


}


if( $_POST['marked'] == "Approve" )
{

//marked timecards will POST and subtract 1 for $_POST["marked"] itself
	$num_approved = count( $_POST ) - 1;

//array_values pulls elements from associative position in POST and places them in numbered elements so the can be accessed by counting the loop
	$approved_row_array = array_values( $_POST );

$y = 0;
while( $num_approved > 0 )
{
	$approved_row = $approved_row_array[$y];
	$contractorid = $current_cards[$approved_row]['contractorid'];
	$weekenddate = $current_cards[$approved_row]['weekenddate'];
	$approved_sql = "UPDATE TimeCards
					 SET Approved = 1
					 WHERE ClientID = $clientid
					 AND ContractorID = $contractorid
					 AND WeekEndDate = '" . $weekenddate . "'";


	echo "<br/>Timecard has been approved. The page will now refresh. <br/>";
	echo "<meta http-equiv='refresh' content='2; url=client.php'>";

	$res_approved = mysql_query( $approved_sql ) or die( "Could not marked Approved: " . mysql_error( ) );
	--$num_approved;
	++$y;
}
}

?>

And here is the second page:

if ( $client_id == 3 ) $client_id = 14;
$sort = $_POST['sort'];
$clientid = $_SESSION['client_id'];


if( $sort == NULL )
{
	$client_display_timecards_sql = 
		"SELECT  Contractor.ContractorFName,
				 Contractor.ContractorLName,
				 TimeCards.ContractorID,
				 TimeCards.Week,
				 TimeCards.PO,
				 TimeCards.TimeCardDate,
				 TimeCards.TimeCardID,
				 TimeCards.TimeIn,
				 TimeCards.BreakBegin,
				 TimeCards.BreakEnd,
				 TimeCards.TimeOut,
				 TimeCards.HoursTotal,
				 TimeCards.WorkDescription
		FROM Contractor 
		JOIN TimeCards
		ON Contractor.ContractorID = TimeCards.ContractorID
		WHERE TimeCards.ClientID = $clientid
		AND TimeCards.Approved = 0";





$res_client_display_timecards = mysql_query( $client_display_timecards_sql )
or die( "Could not do client display cards query: " . mysql_error() );

echo <<<END
<span class="bold">Unapproved Timecards: </span>
<br /><br />
<div class="board" id="board_week_timecards">
	<form action="week.php" method="post">
	<div id="list_week_timecards">
		<table id="table_week_timecards">
			<tr>
				<td class="head_client_left" align="center">PO #</td>
		    	<td class="head_client" align="center">Date</td>
		    	<td class="head_client" align="center">Time In</td>
		    	<td class="head_client" align="center">Break Begin</td>
		    	<td class="head_client" align="center">Break End</td>
		    	<td class="head_client" align="center">Time Out</td>
		    	<td class="head_client_right" align="center">Hours</td>
		 	</tr>

END;

$x = 0;	
while( $client_display_timecards = mysql_fetch_assoc( $res_client_display_timecards ) )
{
	$lname = $client_display_timecards['ContractorLName'];
	$fname = $client_display_timecards['ContractorFName'];
	$contractorid = $client_display_timecards['ContractorID'];
	$week = $client_display_timecards['Week'];
	$po = $client_display_timecards['PO'];
	$timecarddate = $client_display_timecards['TimeCardDate'];
	$timecardid = $client_display_timecards['TimeCardID'];
	$timein = $client_display_timecards['TimeIn'];
	$breakbegin = $client_display_timecards['BreakBegin'];
	$breakend = $client_display_timecards['BreakEnd'];
	$timeout = $client_display_timecards['TimeOut'];
	$hourstotal = $client_display_timecards['HoursTotal'];
	$workdescription = $client_display_timecards['WorkDescription'];
	$current_cards[$x] = array(
	'contractorfname' => "$fname",
	'contractorlname' => "$lname",
	'week' => "$week",
	'po' => "$po",
	'timecarddate' => "$timecarddate",
	'timecardid' => "$timecardid",
	'timein' => "$timein",
	'breakbegin' => "$breakbegin",
	'breakend' => "$breakend",
	'timeout' => "$timeout",
	'hourstotal' => "$hourstotal",
	'workdescription' => "$workdescription"
	);


echo <<<END
		  <tr>
		  	<td class="cell_client_left" align="center">$po</td>
		    <td class="cell_client" align="center">$timecarddate</td>
		    <td class="cell_client" align="center">$timein</td>
		    <td class="cell_client" align="center">$breakbegin</td>
		    <td class="cell_client" align="center">$breakend</td>
		    <td class="cell_client" align="center">$timeout</td>
		    <td class="cell_client_right" align="center">$hourstotal</td>
		  </tr>
		  <tr>
		  	<td class="description_left" align="center"></td>
		  	<td class="description_right" colspan="7">$workdescription</td>
		  </tr>

END;
		++$x;
	}
	echo "

	</table>
</div>
</form>
</div>";

}

[bradgrafelman]

So where are you using the external data from the query string in those URLs -- namely the 'contractorid' parameter?

[brandonpturner]

I'm not sure. I'm not a php guy. I do UI.

I tried to dig in and get this to work because MY PHP guy was busy. However, he IS working on it right now. I'll let you know what happens. Thank you so much for the attention.

[johanafm]

I'd recommend dropping either $client_id = $_SESSION[...] or $clientid = ...

Having two variables containing the exact same thing might make for some bad experiences debugging things later on. Should you for some reason happen to change one of them while not the other, there's a good chance you won't notice that you are in fact using two versions of the same variable and that they suddenly don't have matching values anymore.

[brandonpturner]

First Page:

$sort = $_POST['sort'];

$clientid = $_SESSION['client_id'];
$managerid = $_SESSION['clientcontact_id'];

if( $sort == NULL )

{

// Header Navigation ======================================================================================================
echo <<<END
	<div id="navigation">
		<input name="Submit" type="submit" id="butt_nav_logout" value="" onclick="location.href='index.php';" />
		<input name="Submit" type="submit" id="butt_nav_help" value="" onclick="location.href='help_client.php';" />
		<input name="Submit" type="submit" id="butt_nav_contractors" value="" onclick="location.href='client_contractors.php';" />
	</div>
END;


echo "<div class='content'>";
// Board: Unapproved Timecards ======================================================================================================
echo <<<END
<span class="bold">Unapproved Timecards: </span>
<br /><br />
<div class="board" id="board_client_timecards">
	<div id="list_client_timecards">
	<form action="client.php" method="post">	
		<table id="table_client_timecards">
			<tr>
		    	<td class="head_client_left" align="center">Contractor Name</td>
		    	<td class="head_client" align="center">Week Ending</td>
		    	<td class="head_client" align="center">Total Hours</td>
		    	<td class="head_client_right" align="center">Approve</td>
		  	</tr>

END;

//Query Section ========================================================================================================================

$rs_manager_list = mysql_query( "SELECT ClientID, ClientContactID, ContractorID FROM TimeCards WHERE ClientContactID = $managerid GROUP BY ContractorID" ) or die( "Did not get contractor list: " . mysql_error( ) );

//Loop through rows in query to display selected timecards
	$x = 0;	
	while( $manager_list = mysql_fetch_assoc( $rs_manager_list ) )   //while for query
	{

$rs_manager_contractor = mysql_query( "SELECT ContractorFname, ContractorLname FROM Contractor WHERE ContractorID = " . $manager_list['ContractorID'] ) or die( mysql_error( ) );
$manager_contractor = mysql_fetch_assoc( $rs_manager_contractor );

$rs_manager_clientcontact = mysql_query( "SELECT ClientContactFname, ClientContactLname FROM ClientContacts WHERE ClientContactID = " . $manager_list['ClientContactID'] ) or die( mysql_error( ) );
$manager_clientcontact = mysql_fetch_assoc( $rs_manager_clientcontact );

$manager_timecard_sort_sql = "
	SELECT ContractorID, WeekEndDate, SUM(HoursTotal)
	FROM TimeCards 
	WHERE ClientContactID = " . $manager_list['ClientContactID'] . "
	AND ContractorID = " . $manager_list['ContractorID'] . "
	AND Approved = 0
	GROUP BY WeekEndDate
	ORDER BY WeekEndDate DESC";

$rs_manager_timecard_sort = mysql_query( $manager_timecard_sort_sql ) or die( "Could not get Timecards: " . mysql_error( ) );	
while( $manager_timecard_sort = mysql_fetch_assoc( $rs_manager_timecard_sort ) )
{

$lname = $manager_contractor['ContractorLname'];
$fname = $manager_contractor['ContractorFname'];					//place array values into local vars for easier use in form
$contractorid = $manager_list['ContractorID'];
$totalhours = $manager_timecard_sort['SUM(HoursTotal)'];
$weekenddate = $manager_timecard_sort['WeekEndDate'];

//Build an array while displaying rows so correct row can  be marked approved in DB		
		$current_cards[$x] = array(
		'contractorfname' => "$fname",
		'contractorlname' => "$lname",
		'contractorid' => "$contractorid",
		'weekenddate' => "$weekenddate"
		); //echo "<br/><pre>";print_r( $current_cards );echo "</pre><br/>";

//display data each grouped timecard in table using the loop number as reference to the built array for approval of correct row	
	//Pass parameters to look up timecard detail in week.php	via GET
	echo "<tr>";
		echo "<td class='cell_client_left' align='center'>";
			echo '<a href="week.php?contractorid='.$contractorid.'&weekend=' . $weekenddate .'">' .$fname. " " .$lname. '</a>';
		echo "</td>";

echo <<<END
		    <td class="cell_client" align="center">$weekenddate</td>  

		    <td class="cell_client" align="center">$totalhours</td>
		    <td class="cell_client_right" align="center">
		    	<input type="checkbox" name="approve$x" value="$x" />
		  	</td>

	  </tr>
END;
		++$x;
	}		
	} //while for query

echo "
	</table>

</div>
<input id='butt_client_approve' type='submit' name='marked' value='Approve' />
</form>
</div>
</div>
";


} //if at top


if( $_POST['marked'] == "Approve" )
{

//marked timecards will POST and subtract 1 for $_POST["marked"] itself
	$num_approved = count( $_POST ) - 1;

//array_values pulls elements from associative position in POST and places them in numbered elements so the can be accessed by counting the loop
	$approved_row_array = array_values( $_POST );

$y = 0;
while( $num_approved > 0 )
{
	$approved_row = $approved_row_array[$y];
	$contractorid = $current_cards[$approved_row]['contractorid'];
	$weekenddate = $current_cards[$approved_row]['weekenddate'];
	$approved_sql = "UPDATE TimeCards
					 SET Approved = 1
					 WHERE ClientID = $clientid
					 AND ContractorID = $contractorid
					 AND WeekEndDate = '" . $weekenddate . "'";


	echo "<br/>Timecard has been approved. The page will now refresh. <br/>";
	echo "<meta http-equiv='refresh' content='2; url=client.php'>";

	$res_approved = mysql_query( $approved_sql ) or die( "Could not marked Approved: " . mysql_error( ) );
	--$num_approved;
	++$y;
}
}

Second Page:

$contractorid = $_GET['contractorid'];
$weekend = $_GET['weekend'];

$sort = $_POST['sort'];

$clientid = $_SESSION['client_id'];
$clientcontactid = $_SESSION['clientcontact_id'];

if( $sort == NULL )
{
	$client_display_timecards_sql = 
		"SELECT  Contractor.ContractorFName,
				 Contractor.ContractorLName,
				 TimeCards.ContractorID,
				 TimeCards.Week,
				 TimeCards.PO,
				 TimeCards.TimeCardDate,
				 TimeCards.TimeCardID,
				 TimeCards.TimeIn,
				 TimeCards.BreakBegin,
				 TimeCards.BreakEnd,
				 TimeCards.TimeOut,
				 TimeCards.HoursTotal,
				 TimeCards.WorkDescription
		FROM Contractor 
		JOIN TimeCards
		ON Contractor.ContractorID = TimeCards.ContractorID
		WHERE TimeCards.ClientContactID = $clientcontactid
		AND TimeCards.ContractorID = $contractorid
		AND TimeCards.WeekEndDate = '$weekend'
		AND TimeCards.Approved = 0";





$res_client_display_timecards = mysql_query( $client_display_timecards_sql )
or die( "Could not do client display cards query: " . mysql_error() );

// Header Navigation ======================================================================================================

echo <<<END
<div id="navigation">
	<input name="Submit" type="submit" id="butt_nav_logout" value="" onclick="location.href='index.php';" />
	<input name="Submit" type="submit" id="butt_nav_help" value="" onclick="location.href='help_client.php';" />
	<input name="Submit" type="submit" id="butt_nav_timecards" value="" onclick="location.href='client.php';" />
</div>
END;

echo "<div class='content'>";
echo <<<END
<span class="bold">Unapproved Timecards: </span>
<br /><br />
<div class="board" id="board_week_timecards">
	<form action="week.php" method="post">
	<div id="list_week_timecards">
		<table id="table_week_timecards">
			<tr>
				<td class="head_client_left" align="center">PO #</td>
		    	<td class="head_client" align="center">Date</td>
		    	<td class="head_client" align="center">Time In</td>
		    	<td class="head_client" align="center">Break Begin</td>
		    	<td class="head_client" align="center">Break End</td>
		    	<td class="head_client" align="center">Time Out</td>
		    	<td class="head_client_right" align="center">Hours</td>
		 	</tr>

END;

$x = 0;	
while( $client_display_timecards = mysql_fetch_assoc( $res_client_display_timecards ) )
{
	$lname = $client_display_timecards['ContractorLName'];
	$fname = $client_display_timecards['ContractorFName'];
	$contractorid = $client_display_timecards['ContractorID'];
	$week = $client_display_timecards['Week'];
	$po = $client_display_timecards['PO'];
	$timecarddate = $client_display_timecards['TimeCardDate'];
	$timecardid = $client_display_timecards['TimeCardID'];
	$timein = $client_display_timecards['TimeIn'];
	$breakbegin = $client_display_timecards['BreakBegin'];
	$breakend = $client_display_timecards['BreakEnd'];
	$timeout = $client_display_timecards['TimeOut'];
	$hourstotal = $client_display_timecards['HoursTotal'];
	$workdescription = $client_display_timecards['WorkDescription'];
	$current_cards[$x] = array(
	'contractorfname' => "$fname",
	'contractorlname' => "$lname",
	'week' => "$week",
	'po' => "$po",
	'timecarddate' => "$timecarddate",
	'timecardid' => "$timecardid",
	'timein' => "$timein",
	'breakbegin' => "$breakbegin",
	'breakend' => "$breakend",
	'timeout' => "$timeout",
	'hourstotal' => "$hourstotal",
	'workdescription' => "$workdescription"
	);


echo <<<END
		  <tr>
		  	<td class="cell_client_left" align="center">$po</td>
		    <td class="cell_client" align="center">$timecarddate</td>
		    <td class="cell_client" align="center">$timein</td>
		    <td class="cell_client" align="center">$breakbegin</td>
		    <td class="cell_client" align="center">$breakend</td>
		    <td class="cell_client" align="center">$timeout</td>
		    <td class="cell_client_right" align="center">$hourstotal</td>
		  </tr>
		  <tr>
		  	<td class="description_left" align="center"></td>
		  	<td class="description_right" colspan="7">$workdescription</td>
		  </tr>

END;
		++$x;
	}
	echo "

	</table>
</div>
</form>
</div>
</div>";

}