Is there a way to load only the fields that i require for specific type of invoice (AbleInvForm,courtemplate,InterprGroup,WSIBSpeakInvo,WSIBWriteInvo)
I want to be able to pull down that menu (which I am already doing, but I wish for selective files to show up; so I can fill them out) or perhaps if that cannot be done, then maybe change the colours of specific files to person knows which ones to fill out.
Thanks.
$query = "SELECT * FROM `blue` WHERE 1";
$result = mysql_query($query)
or die ("nothing");
$todaynow = Time();
$date = date("Y-m-d",$todaynow);
$q = mysql_query("show table status from haha like 'blue'") or die(mysql_error());
$invoice = mysql_result($q, 0, 'Auto_increment');
echo "<font size='+1'><b>Add New Invoice !!</b></font>
<form action='addinginvoice.php' method='post'>
<left>
<table border='0' cellspacing='0' cellpadding='0'>
<tr><td class='txt11b' align='right'>Invoice: </td><td class='txt11'>
<input name='invoice' class='box12' size='24' value='$invoice'>
</tr>
<tr><td class='txt11' align='right'>Date: </td><td class='txt11'>
<input name='date' class='box12' size='10' maxlength='10' value='$date'></td>
<tr><td class='txt11b' align='right'>Client: </td>
<td>
<input type='hidden' name='addressid' class='box12'>
<select class='box12' name='addressid'>
<option value='' selected='selected'>-->> Select your Client</option>";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<option value='$addressid'>$addressid : $client1 | $name</option>";
}
echo "</select></td>
</tr>
<tr><td class='txt11b' align='right'>Invoice Type: </td>
<td>
<input type='hidden' name='invoiceid' class='box12'>
<select class='box12' name='invoiceid'>
<option value='' selected='selected'>-->> Select your Invoice Style</option>
<option>AbleInvForm</option>
<option>courtemplate</option>
<option>InterprGroup</option>
<option>WSIBSpeakInvo</option>
<option>WSIBWriteInvo</option>
</select>
</td>
</tr>
<tr><td class='txt11' align='right'><font color='red'>Subject #1, Line #1: </font></td>
<td> <input class='box12' name='subject1' size='65' maxlength='65' value='$subject1'> </td>
</tr>
<tr><td class='txt11' align='right'>Sub1, Line #2: </td>
<td> <input class='box12' name='subject2' size='65' maxlength='65' value='$subject2'> </td>
</tr>
<tr><td class='txt11' align='right'>Sub1, Line #3: </td>
<td> <input class='box12' name='subject3' size='65' maxlength='65' value='$subject3'> </td>
</tr>
<tr><td class='txt11' align='right'><font color='red'>Subject #2, Line #1: </font></td>
<td> <input class='box12' name='subject4' size='65' maxlength='65' value='$subject4'> </td>
</tr>
<tr><td class='txt11' align='right'>Sub2, Line #2: </td>
<td> <input class='box12' name='subject5' size='65' maxlength='65' value='$subject5'> </td>
</tr>
<tr><td class='txt11' align='right'>Sub2, Line #3: </td>
<td> <input class='box12' name='subject6' size='65' maxlength='65' value='$subject6'> </td>
</tr>
<tr><td class='txt11' align='right'>Requisitioned: </td>
<td> <input class='box12' name='requisitioned' size='65' maxlength='65' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Words #1: </td>
<td> <input class='box12' name='words1' size='10' maxlength='10' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Words #2: </td>
<td> <input class='box12' name='words2' size='10' maxlength='10' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Amount #1: </td>
<td> <input class='box12' name='amount1' size='10' maxlength='10' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Amount #2: </td>
<td> <input class='box12' name='amount2' size='10' maxlength='10' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Location:</td>
<td> <input class='box12' name='location' size='65' maxlength='65' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Claimant:</td>
<td> <input class='box12' name='claimant' size='65' maxlength='65' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Start Time (24 hour (11:45)):</td>
<td> <input class='box12' name='stime' size='6' maxlength='6' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>End Time (24 hour (11:45)):</td>
<td> <input class='box12' name='etime' size='6' maxlength='6' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Court ID:</td>
<td> <input class='box12' name='courtid' size='20' maxlength='20' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Travel (kms):</td>
<td> <input class='box12' name='kms' size='12' maxlength='12' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Shipping ($):</td>
<td> <input class='box12' name='shipping' size='12' maxlength='12' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Lunch ($):</td>
<td> <input class='box12' name='lunch' size='12' maxlength='12' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Parking ($):</td>
<td> <input class='box12' name='parking' size='12' maxlength='12' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Delivery:</td>
<td> <input class='box12' name='delivery' size='65' maxlength='65' value=''> </td>
</tr>
<tr><td class='txt11' align='right'>Translation:</td>
<td>
<input type='radio' name='translation' value='polish' class='box12'>POLISH to ENGLISH
<input type='radio' name='translation' value='english' class='box12'>ENGLISH to POLISH
</td>
</tr>
</table>
<P>
<input type='submit' value='Are you sure you want to ADD INVOICE?'>
</form> </td>
</tr>
</table>
";
?>
