php include file works one time

db96s1

i am using a drop down list box to use as an order selector. when i include this file in the first web page it works fine. the selection process calls a second page and it is at this page that i cannot make the same include file work. no messages just a second screen that breaks and stops with only the drop down list box, no other part of the screen. i have tested the mysqli_free_result thinking it may be an issue and that did nothing. i tried a mysqli_data_seek thinking it might be still in memory, not useful either. i am puzzled again.

thanks in advance for your time and thoughts.

dan bloch

first instance/page code:

<table border="1" width="800" cellspacing="1" cellpadding="1" align="center" >
<tr>
<td><B>Select Reservation:</B></td>
<td>
<select name="SelectReservation" style="width:300px" onChange="jumpPage('Reservation', this.form.SelectReservation)" >
<option value="" SELECTED></option>
<?php
include("INC/srvsrqst_transSelector.php");
?>
</select>
<input Type="Submit" value="Submit">
<input Type="Reset" value="Reset" >
</td>
</tr>
</table>

second instance/page code:

include("INC/srvsrqst_transSelector.php");

?>
</select>
<input Type="Submit" value="Submit">
<input Type="Reset" value="Reset" >
</td>
</tr>
</table>

the srvsrqst_transSelector include file:

<?php

$clientID = $_SESSION['clientID'];

$rst_getClientRsvtns = sprintf("
SELECT
transAction.transActionID ,
transAction.userName ,
transAction.transStartDate ,
transAction.transEndDate ,
transAction.transStartTime ,
transAction.transEndTime ,
transAction.active,
transAction.activeText
FROM transAction
WHERE (((transAction.clientID)='%s'))
ORDER BY transAction.transStartDate ASC " ,
mysqli_real_escape_string( $link, $clientID ));
$rst_getClientRsvtns_results = mysqli_query($link, $rst_getClientRsvtns) or die("SQL ERROR transSelector ".mysqli_error($link));
while ($row = mysqli_fetch_array($rst_getClientRsvtns_results, MYSQLI_ASSOC))
{
$StartDate = formatSQLDate_MDY ($row['transStartDate']) ;
$EndDate = formatSQLDate_MDY ($row['transEndDate']) ;
$activeText =$row['activeText'];
?>
<option value = " <?php echo $row['transActionID'] ?> "> <?php echo $StartDate." - ".$EndDate." - ".$activeText ?> </option> ;
<?php
}
//mysqli_free_result($rst_getClientRsvtns);
?>