[esandra]

//i've been looking at this same code for two whole days now and ive changed it lots of times but it can only get worse
//i can't pass the value of the variable $today which has a date datatype
//this is the part where i get the value of $today

PHP Code:

 <?php 
           $query="SELECT DISTINCT date FROM arrastre order by today desc";
           $result=mysql_query($query);
           while($row=mysql_fetch_object($result)){
                   $today=$row->today;    
            echo "<option value=$today>$today</option>";
           }
           ?>

//here's is the part where i use $today to get $tcl
//except for a major problem that when the while loop returns more than one $tcl, i get more than one button, but that's not the problem because that is how it's supposed to work. The problem is that when there are more than one buttons, only the last button would work, the only button that displays values

PHP Code:

 <?php 
        if(isset($_POST['godate'])){
            $today=$_POST['today'];
            $query="SELECT DISTINCT tcl FROM arrastre WHERE today='$today' ORDER BY tcl ASC";
            $result=mysql_query($query);
            while($row=mysql_fetch_array($result)){
                $tcl=$row['tcl'];
                $today=$row['today'];
                ?>
                <input type="hidden" name="tcl" value="<?php echo $tcl;?>">
                <input type=submit name="tcl" value="<?php echo $tcl; ?>">
        <?php        } }
        ?>

//thsi is another problem

PHP Code:

if(isset($_POST['tcl'])){    
            $tcl=$_POST['tcl'];
            $today=$_POST['today'];
            $query = "select * from arrastre where tcl=$tcl and today='$today' order by tcl asc";
            $result = mysql_query($query);
            $totalcollections = 0;
            while($row=mysql_fetch_array($result)){
                $orno=$row['orno'];
                $billnmbr=$row['billnmbr'];
                $payor=$row['payor'];
                $arrastre=$row['arrastre'];
                $wharfage=$row['wharfage'];
                $total=$row['total'];
                $today=$row['today'];
//*i deleted the display part to make this shorter a little
}} 

//the $today variable is empty in this post and i have no idea how to successfully pass this value
so i could use it in my $query
//thanks for your time

[omkarvjoshi1982]

echo "<option value=$today>$today</option>";
instead of using the above method try to use following method
echo "<option value='".$today."'>$today</option>";
--------------------------------------------------------------------
<input type=submit name="tcl" value="<?php echo $tcl; ?>">
instead of using the above method try to use following method
<input type=submit name="tcl[ ]" value="<?php echo $tcl; ?>"> // this will give you an array named tcl
--------------------------------------------------------------------

instead of accessing today named variable try to access <select name='what_ever_name_you_have_given'>

this will give you the exact date

[esandra]

Originally Posted by omkarvjoshi1982

echo "<option value=$today>$today</option>";
instead of using the above method try to use following method
echo "<option value='".$today."'>$today</option>";
--------------------------------------------------------------------
<input type=submit name="tcl" value="<?php echo $tcl; ?>">
instead of using the above method try to use following method
<input type=submit name="tcl[ ]" value="<?php echo $tcl; ?>"> // this will give you an array named tcl
--------------------------------------------------------------------

instead of accessing today named variable try to access <select name='what_ever_name_you_have_given'>

this will give you the exact date

Thank you,
i don't have an idea how to use the value of tcl from this line
<input type=submit name="tcl[ ]" value="<?php echo $tcl; ?>">
since im going to call its value in my last query..it returns an error upon calling my query because its an array