my problem is the following
<?
include"./common1.inc";
cheader();
$user=$REMOTE_USER;
function change()
{
}
function upload_form()
{
global $PHP_SELF,$user;
echo "<H2 ALIGN='CENTER'><font color=\"BLUE\"><U>Checkin Request Page For</U></font><H2>";
echo"<H3 ALIGN='CENTER'> User Name    $user</H3>";
?>
<FORM NAME="form1" METHOD="post" ENCTYPE="MULTIPART/FORM-DATA" ACTION="<? echo $PHP_SELF ?>">
<TABLE ALIGN="CENTER"WIIDTH="90%" BORDER="1" BORDERCOLOR="RED" cellspacing=0>
<TR>
<TH ALIGN="CENTER" WIDTH="90%">Input File!
<TD>
<TABLE WIDTH="100%" cellspacing=0><TD><INPUT TYPE="FILE" NAME="file1"ONMOUSEMOVE="pop('Please Choose Zip files For Multiple file Selecting','#BBEEAA')" ONMOUSEOUT="kill()";>
<TH ALIGN="RIGHT">Review_Report
<TD><INPUT TYPE="file" NAME="review" ONMOUSEMOVE="pop('Please Choose Zip files For Sending Multiple files','#BBEE88')" ONMOUSEOUT="kill()";>
</TABLE>
<TR>
<TH ALIGN="CENTER" WIDTH="30%" ><B>Checkin Details</B></TH>
<TD WIDTH="70%">
<TABLE WIDTH="100%" border="1">
<TR>
<TH>date
<TD><? echo gmdate("d-m-Y") ?>
<INPUT TYPE="HIDDEN" NAME="cindate" VALUE=<?php echo gmdate("Y-m-d");?> >
<TH>Change_type
<TD><SELECT NAME="changetype">
<?
$result=db_connect1("SELECT DISTINCT changetype FROM details ");
while($data1=mysql_fetch_row($result))
echo"<OPTION VALUE='$data1[0]'>$data1[0]</OPTION>";
?>
<TR>
<TH>project
<TD><SELECT NAME="project" ONCHANGE="change()">
<?
$result=db_connect1("SELECT DISTINCT project FROM details");
while($data1=mysql_fetch_row($result))
echo"<OPTION VALUE='$data1[0]'>$data1[0]</OPTION>";
?>
</SELECT>
<TH>Man_Effort.hrs
<TD><INPUT TYPE="TEXT" NAME="maneffort" VALUE=0>
<TR>
<TR>
<TH>module
<TD><SELECT ID="mod" NAME="module">
<?
$result=db_connect1("SELECT DISTINCT module FROM details ORDER BY module");
while($data=mysql_fetch_row($result))
{
echo"<OPTION VALUE='$data[0]'> $data[0] </OPTION> ";
}
?>
</SELECT>
<TH ALIGN="CENTER">Review_effort.hrs
<TD><INPUT TYPE="TEXT" NAME="reviewhours" VALUE=0>
<TR>
<TH>Priority
<TD><SELECT NAME="priority">
<?
$result=db_connect1("SELECT DISTINCT priority FROM details");
while($data1=mysql_fetch_row($result))
echo"<OPTION VALUE='$data1[0]'>$data1[0]</OPTION>";
?>
</SELECT>
<TH ALIGN="CENTER"">Submission type
<TD><SELECT NAME="submissiontype">
<?
$result=db_connect1("SELECT DISTINCT submissiontype FROM details ORDER BY submissiontype");
while($data=mysql_fetch_row($result))
{
echo"<OPTION VALUE='$data[0]'> $data[0] </OPTION> ";
}
?>
</SELECT>
<TD>
<TR>
<TH>Doc_Status
<TD><SELECT NAME="docstatus">
<?
$result=db_connect1("SELECT DISTINCT docstatus FROM details ");
while($data=mysql_fetch_row($result))
{
echo"<OPTION VALUE='$data[0]'> $data[0] </OPTION> ";
}
?>
</SELECT>
<TH>Version
<TD><INPUT TYPE="TEXT" NAME="version" VALUE=0>
</TABLE>
<TR>
<TH ALIGN="CENTER">Change Description
<TD><TEXTAREA NAME="changes" rows=8 cols=63 ></TEXTAREA></TR>
<TR>
<TH> <TD ALIGN="CENTER">
<TABLE ALIGN="CENTER" WIDTH="30%">
<TD ALIGN="LEFT"><INPUT TYPE="SUBMIT" NAME="action" VALUE="submit">
<TD ALIGN="RIGHT"><INPUT TYPE="RESET" VALUE="clear">
</TABLE>
</TABLE>
</FORM>
</DIV>
<?
footer()
?>
Here When the event is changed the the function should return some value for the another dropdown menu named module
How I have to perform it, But From java script We can't connect the Mysql
How to recover it?
Advance Greeting