Hi, I would like to be able to query a table, if the employee_start is null, then I would like to query another table to get the list of all employees into a select list, if it is not null, then I would like it to put the employee_start as an echo in a text box. I am wondering if this can be done.
something like (obviously this code is totally incorrect, but shows, I believe, what I sort of want to do) this would go in (or around, line 59 of the second section of code below.
<?php
$query = " SELECT * FROM `honeybee_admin_tbl`";
$result = mysql_query($query);
if($result)
{
while ( $task = mysql_fetch_array($result) )
{
$task_number=$task['task_number'];
$task_id=$task['task_id'];
$date_start=$task['date_start'];
$employee_start=$task['employee_start'];
$date_finish=$task['date_finish'];
$employee_finish=$task['employee_finish'];
$notes=$task['notes'];
if ($employee_start == 'NULL')
{
$query_employee="SELECT employee_name FROM employee'";
$result = mysql_query($query_employee);
echo '<select name="employee_start" id="employee_start">
<option value="" selected>Choose Employee</option>
<?php
for ($i=0; $i < mysql_num_rows($result); $i++)
{
$row = mysql_fetch_array($result); ?>
<option value="<?php echo $task['employee_name']; ?>"><?php echo $task['employee_name']; ?></option>
<?php
} ?></select>'
}
else
}
echo '<input type="text" name="employee_start" value="<? echo $employee_start; ?>">';
}
else
{
?>
Right now, this lists all tasks in a table at line 59 is the employee_start. I left the html code in here.
<?php require_once('db_fns.php');
$conn = db_connect();
if (!$conn)
return 'Could not connect to database server - please try later.';
$query = " SELECT * FROM `honeybee_admin_tbl`";
$result = mysql_query($query);
if($result)
{
while ( $task = mysql_fetch_array($result) )
{
$task_number=$task['task_number'];
$task_id=$task['task_id'];
$date_start=$task['date_start'];
$employee_start=$task['employee_start'];
$date_finish=$task['date_finish'];
$employee_finish=$task['employee_finish'];
$notes=$task['notes'];
?>
<form name="showingtasks" action="update.php" method="post">
<input type="hidden" name="task_id" value="<?php echo $task_id; ?>">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="12%" bgcolor="#666666" class="pdheaderwhite">File <? echo $task_number; ?>:</td>
<td width="27%" bgcolor="#666666" class="pdheaderwhite"><? echo $task_id; ?></td>
<td width="61%" bgcolor="#CCCCCC" class="pdheader">Trouble Tickets</td>
</tr>
<tr>
<td bgcolor="#FFEDD4" class="pdtext">Date Started:</td>
<td bgcolor="#FFEDD4"><input type="text" name="date_start" value="<? echo $date_start; ?>"></td>
<td rowspan="5" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="3" class="pdtext">
<tr>
<td><strong>Title</strong>
<td><strong>Assigned To:</strong></td>
<td><strong>Date Opened</strong></td>
</tr>
<? $sql = "SELECT ticket_id, ticket_shortname, ticket_assigned_to, ticket_date_opened FROM honeybee_adminticket_tbl WHERE task_id = '$task_id' AND ticket_date_closed IS NULL";
$res = mysql_query($sql) or die (mysql_error());
if($res)
{
while (list($task_id, $name, $assign, $date) = mysql_fetch_row($res))
{
echo"<tr><td><a href='ticketinfo.php?ticket_id=$task_id'>$name</a>
<td>$assign</td>
<td>$date</td></tr>";
}
} ?>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td class="pdtext"><p><?php echo "<a href='troubleticket.php?task_number=".$task['task_number']."'>Add New Ticket</a>" ?> </p>
<p><a href="opentickets.php">View All Open Tickets</a></p>
</td>
</tr>
</table>
<p> </p></td>
</tr>
<tr>
<td bgcolor="#FFEDD4" class="pdtext">Employee Responsible:</td>
<td bgcolor="#FFEDD4"><input type="text" name="employee_start" value="<? echo $employee_start; ?>"></td>
</tr>
<tr>
<td bgcolor="#FFEDD4" class="pdtext">Date Completed</td>
<td bgcolor="#FFEDD4"><input type="text" name="date_finish" value="<? echo $date_finish; ?>">
</td>
</tr>
<tr>
<td bgcolor="#FFEDD4" class="pdtext">Employee Resonsible:</td>
<td bgcolor="#FFEDD4"><input type="text" name="employee_finish" value="<? echo $employee_finish; ?>"></td>
</tr>
<tr>
<td bgcolor="#FFEDD4" class="pdheader"> </td>
<td bgcolor="#FFEDD4"> </td>
</tr>
<tr>
<td bgcolor="#FFEDD4" class="pdtext">Notes:</td>
<td colspan="2" bgcolor="#FFEDD4"><p>
<textarea name="notes" cols="60" rows="5"><? echo $notes; ?></textarea>
</p>
</td>
</tr>
<tr>
<td bgcolor="#FFEDD4" class="pdheader"> </td>
<td bgcolor="#FFEDD4"><input name="Submit" type="Submit" value="Update"></td>
<td bgcolor="#FFEDD4"> </td>
</tr>
<tr>
<td class="pdheader"> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<?
}
}
?>
Any help is much appreciated. thnx
