PHP - Moved: How To Get Data Between Two Same Dates When Datefield Is Datetime

Hi All,

I need to subtract dates and display the number of days left.  I have a 'Start' date and an 'End' date in DATETIME format in the DB.  Not quite sure where to start.  A simply start - end doesn't work  .

Start = 2011-11-01-00:00:00
End = 2011-11-30-23:59:59

Since it is now 2011-11-27, my output should equal 3.  Any help is appreciated.

SELECT * FROM `booking_tbl` WHERE booking_status = 'Check In' AND departure_date_time = NOW()"

I use the datetime datatype for the departure_date_time so i can get data from that data because it checking the date and time   but i want it to check on the date from the datetime datatype   So how can i get the data only with that date without the time in the mysql datetime datatype

I am using a query to select everything out of a table in to an array. I have 4 fields as follows name, email, comment and datatime. What i want to do is use one of the stated function to grab the datetime elements and split them at the break point, but i am displaying more than one record with in the table, i think this is were i am fucking up.

for example i tryied this:
Code: [Select]
                $commentsTable = "comments";
            $comments = "SELECT * FROM  $commentsTable";
$commentResults = mysql_query($comments);
$commentRows = mysql_fetch_array($commentResults);

$dateTimeSplit = explode(" ", $commentRows['datetime']);

               
               <?php while($commentRows = mysql_fetch_array($commentResults)){?>
    <div id="comments">
    <div id="CommentWrapper">
            <div id="comment">
                <div id="UserComment"><? echo $commentRows['comment'];?></div>
                 // here is were am having the problem!!!
                <div id="PostDateTime"><i>Posted: </i><? echo $dateTimeSplit['0'];?><i> Time: </i><? echo $dateTimeSplit['1'];?></div>
            </div>
        </div>
    </div>
<?php } mysql_close(); ?>

any sudgestions?

Hi,

I'm trying to get the records that are between two dates to show on my screen, right now nothing comes up my code I'm using is below

Code: [Select]
$today = date('Y-m-d');
$lastweek = date('Y-m-d',strtotime('-7 days'));
$sql = "SELECT * from `memos` WHERE `date` BETWEEN '$today' AND '$lastweek' AND `delete` !='1'";
$result = mysql_query($sql);
echo "<ol>";
while ($row = mysql_fetch_array($result)) {
echo "<li>".$row['memo']."</li>" ;
}
echo "</ol>";

Dear all,

how can I convert a string "yyyy-mm-dd hh:mm" into a really datetime value with php?

thanks!