PHP - Select * Where Date Is Between

I have a calendar select date function for my form that returns the date in the calendar format for USA: 02/16/2012.  I need to have this appear as is for the form and in the db for the 'record_date' column, but I need to format this date in mysql DATE format (2012-02-16) and submit it at the same time with another column name 'new_date' in the database in a hidden input field.  Is there a way to do this possibly with a temporary table or something?

Any ideas would be welcome.

Doug

So I have this program I purchased and it allows me to create custom form fields. I have been trying to create a date select box but have been struggling because I am just learning php. I was wondering if someone could lend a hand.  I will try and give as much info as i can.  First I will show a picture of the custom field box and then i will give the description of both boxes that the company gave me. Next i will give you the php code i have been trying to work with. Please if my code is not the best then i will take any advice. I found the code for the date selector online.



Parsed Default Value  -   You may specify a variable or a function as the default value; for example $_SERVER[HTTP_USER_AGENT] or mktime()


Parsed PHP Code -    You can specify actual PHP code that will be used to return a variable. // You should assign the value you wish to use to the variable $str.


Code: [Select]
<?PHP
 
FUNCTION buildDate($name, $m, $d, $y) {
        $date = DATE("m-d-Y",STRTOTIME("now"));
        $date_array = EXPLODE("-",$date);
        $now_m = "";
        $now_d = "";
        $now_y = "";
        $month = '<select class="small" name="'.$name.'_month">';
        $month .= '<option value="" selected disabled>mm</option>';
        FOR ($i=1;$i<=12;$i++) {
                IF ( $m != "" ) {
                        IF ( $m == $i ) {
                                $now_m = "selected";
                        }
                }ELSEIF ( $m == "0" ) {
                        $now_m = "";
                }ELSE{
                        IF ( $date_array[0] == $i ) {
                                $now_m = "selected";
                        }
                }
                $month .= '<option value="'.$i.'" '.$now_m.'>'.$i.'</option>';
                $now_m = "";
        }//END month for loop
        $month .= '</select>';
        $day = '<select class="small" name="'.$name.'_day">';
        $day .= '<option value="" selected disabled>dd</option>';
        FOR ($i=1;$i<=31;$i++) {
                IF ( $d != "" ) {
                        IF ( $d == $i ) {
                                $now_d = "selected";
                        }
                }ELSEIF ( $d == "0" ) {
                        $now_d = "";
                }ELSEIF ( $d == $i ) {
                        $now_d = "selected";
                }ELSE{
                        IF ( $date_array[1] == $i ) {
                                $now_d = "selected";
                        }
                }
                $day .= '<option value="'.$i.'" '.$now_d.'>'.$i.'</option>';
                $now_d = "";
        }//END day for loop
        $day .= '</select>';
        $year = '<select class="small" name="'.$name.'_year">';
        $year .= '<option value="" selected disabled>yyyy</option>';
        FOR ($i=GMDATE("Y"); $i <=SUBSTR(get330Date(),0,4); $i++) {
                IF ( $y != "" ) {
                        IF ( $y == $i ) {
                                $now_y = "selected";
                        }
                }ELSEIF ( $y == "0" ) {
                        $now_y = "";
                }ELSEIF ( $y == $i ) {
                        $now_y = "selected";
                }ELSE{
                        IF ( $date_array[2] == $i ) {
                                $now_y = "selected";
                        }
                }
                $year .= '<option value="'.$i.'" '.$now_y.'>'.$i.'</option>';
                $now_y = "";
        }//END year for loop
        $year .= '</select>';
        //-------------------------------------------
        ECHO $month." ".$day." ".$year;
}//END buildDate function
// ------------------------------------
FUNCTION get330Date() {
        RETURN DATE("Y-m-d", MKTIME(0, 0, 0, SUBSTR(GMDATE("Y m d"),5,2),
        SUBSTR(GMDATE("Y m d"),8,2) + 330,
        SUBSTR(GMDATE("Y m d"),0,4)))."<br />";
}
 
?>



I might just be totaly wacked here with what i am trying to do but i am sure someone will tell me one way or the other. lol

hello with tis button i generate some statistics from mysql


if(isset($_POST['sub1']))

                                {
           
                                    $result = mysql_query("SELECT servitoros1, COUNT(*) from history WHERE serv LIKE '%be%'  group by serv1");
                                   
                                    while($row = mysql_fetch_row($result))
                                                                           {
                                                                               


                                          echo "<tr>";
                                                                                 foreach($row as $cell)
                                                                           
                                                                            echo "<td ALIGN=\"center\">$cell<FONT></td>";   
                                                    
                                                                                    echo "</tr>\n";
                                                                               
                                                                           }
                                   
                                   
                                    mysql_free_result($result);
                 
                            }


               
                      but each record have datetime field!!


so how can i set this display betwean 2 selectable datetimes

e.g.

from 2/2/2011 15:45   to  3/2/2011 23:59

Hi all,

I have done a script that works fine on a single basis...

SELECT * FROM company
WHERE so <> 0
AND so_active = 'yes'
AND DATE_FORMAT(so_start_date, '%e') = '18'
ORDER BY company_name ASC

The problem I have is when I try to do a range...

SELECT * FROM company
WHERE so <> 0
AND so_active = 'yes'
AND DATE_FORMAT(so_start_date, '%e') BETWEEN '5' AND '26'
ORDER BY company_name ASC

It should return at least 1 result as I am looking for '18', any help would be much appreciated.

Many Thanks.

Hi,

How can I check mysql date/time field for all records with tommorows date.. ?


Thanks