Ok, here is what I want to do.
I have a script that selects from mysql db
<?php
session_start();
include_once ("auth.php");
include_once ("authconfig.php");
include_once ("check.php");
if ($check['level'] > 4)
{
echo 'You are not allowed to access this page.';
exit();
}
include("header.php");
?>
<form name="form" enctype='multipart/form-data' action='dataentry.php' method='post'>
<div align="center">
<center>
<table border="0" cellspacing="1" style="border-collapse: collapse" bordercolor="#000066" width="562" cellpadding="5">
<tr><td colspan="2" height="16" width="544" bordercolor="#FFFFFF" background="tile_sub.gif">
<p align="center"><b><font face="Verdana" size="2" color="#000066">
<font size="2" face="Verdana">
<! You can add a brief form description here-->
</font></font><font face="Verdana" size="4">Select Office</font></b></p>
</td></tr><tr><td colspan="2" height="16" width="544">
<p align="center"><font size="1" face="Verdana"></font></p>
</td></tr><tr><td height="30" width="201" align="right">
<font face="Verdana" size="2"><b>Office</b></font></td>
<td height="30" width="329">
<font face="Verdana"><select size="1" name="Office" onChange="this.form.submit();">
<option selected>Select Office</option>
<option value="100100">Bicknell</option>
<option value="100200">Indy</option>
<option value="100300">Louisville</option>
</select></font></td></tr>
</table></center>
</div>
</form>
<?php
$link = mysql_connect("localhost","connexio","mypassword");
mysql_select_db("connexio_dataentry",$link);
$query = "SELECT * FROM import ORDER BY WorkOrderDate, MgtArea, TimeFrame";
$result = mysql_query($query)
or die(mysql_error());
?>
<p></p><b>
<div align="center">
<center>
<table border="0" cellpadding="2" width="100%">
<tr>
<td width="100%" bgcolor="#FF0000">
<p align="center"><b><font color="#FFFFFF" size="5"> *** Open Work
***</font></b></td>
</tr>
</table>
</center>
</div>
<p></p>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#EBEBEB">
<tr>
<td width="12%"><font size="2"><b>Account Number</td>
<td width="10%"><font size="2"><b>Scheduled Date</td>
<td width="7%" align="center"><font size="2"><b>MgtArea</td>
<td width="7%" align="center"><font size="2"><b>TimeFrame</td>
<td width="7%" align="center"><font size="2"><b>Type</td>
<td width="25%"><font size="2"><b>Name</td>
<td width="14%"><font size="2"><b>Home Phone</td>
<td width="15%"><font size="2"><b>City</td>
</center>
<td width="10%">
<p align="right"><font size="2"><b>Tech</b></font></p>
</td>
</tr>
</table>
</div>
</b><p></p>
<?php
#display results
while($i = mysql_fetch_array($result))
{
$id = $i['id'];
$AccountNumber = $i['AccountNumber'];
$WorkOrderDate = $i['WorkOrderDate'];
$MgtArea = $i['MgtArea'];
$TimeFrame = $i['TimeFrame'];
$WorkOrderType = $i['WorkOrderType'];
$FirstName = $i['FirstName'];
$LastName = $i['LastName'];
$HomePhone = $i['HomePhone'];
$City = $i['City'];
$Tech = $i['Tech'];
?>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%"bgcolor=" ">
<tr>
<td width="12%"><font size="2"><?php echo "<a href=account_select.php target=_blank>$AccountNumber"?></td>
<td width="10%"><font size="2"><?php echo $WorkOrderDate?></td>
<td width="7%"><font size="2"><?php echo $MgtArea?></td>
<td width="7%"><font size="2"><?php echo $TimeFrame?></td>
<td width="7%"><font size="2"><?php echo $WorkOrderType?></td>
<td width="25%"><font size="2"><?php echo $FirstName; echo " "; echo $LastName?></td>
<td width="14%"><font size="2"><?php echo $HomePhone?></td>
<td width="15%"><font size="2"><?php echo $City?></td>
<td width="10%"><p align="right"><font size="2"><?php echo $Tech?></font></td>
</tr>
</table>
</center>
</div>
<?php
}
include("footer.php");
?>
It has this print out.
View Page
What I want to be able to do is click on the account number I want and have it go to a form (dataentry.php) and populate it with that account numbers information.
I have been searching but can't find anything on how to accomplish this.
Thanks for the help.
