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