Hi Friends,
since i am new to this script, I need your help, well this is my problem, i need to compare userdate with my backend date. for that i have used a dynamic dropdown combo as an id and i need to fetch the date associated with that id and need to compare with the user date in a hidden format. once the user press the calculate button it has to compare the user date and the hidden backend date and it has to display some values based on some condition.. this is the task. well i am displaying the coding also. Thank you friends.
<?php
$con=mysql_connect("localhost","root","");
if(!con)
{
die("could not connect to the database".mysql_error());
}
$db=mysql_select_db("srijesh",$con);
echo "connection succed";
$qry="select DISTINCT C from sheet1 ORDER BY C";
$result=mysql_query($qry);
?>
<html>
<head>
<title> service calculator </title>
<script type="javascript">
function fnsubmit()
{
window.document.f1.method="post";
window.document.f1.submit();
}
</script>
</head>
<body bgcolor="pale red">
<form name="f1" method="post" action="1.php">
<h1>Date comparing</h1>
<hr>
<center><p>Taxable Service:</td><td><select name="taxservice" onChange="fnsubmit()">
<option value=""></option>
<?php
while($row=mysql_fetch_array($result))
{
if($_POST== $row)
{
$selected = 'selected';
}
else
{
$selected = '';
}
echo $selected;
echo "<option value='".$row."' $selected;>.$row."</option>";
}
?>
</select></p>
<p>user date:<input type="text" name="userdt" value=""></p>
<p>date compare:<input type="button" name="dtcompare" value="datecompare"> </p>
<p>ess:<input type="text" name="ess" value=""> </p>
<p>total:<input type="text" name="tot" value=""> </p>
</center> </form></body></html>
