Select database where datetime>now()?
I have 2 questions:
How can i select the data from the database where datetime>now() by writing php code?
if there is the data from the database where datetime>now() , i want select the last two value from the database. what should i do?
I'm doing my gps tracking website. At the moment,my page is just select the last data to show the last position on the map. What i want is ,when i login my page, i will see the final position of the vehicle, and if the vehicles moves(mean the datetime of the data in database>now(), i want to select the 2 last updated data frequently to caculate the distance
- Store now() in a variable and then compare using where clause.
Update :<?php $timeZone = 'Asia/Kolkata'; //variable for indian timezone date_default_timezone_set( $timeZone); //default timezone set to indian time $now = date("m/d/y G.i:s"); echo $now; ?>