topflight Posted February 11, 2010 Share Posted February 11, 2010 Hello I have a table called called flights where it has all my flights info. But in that table I have a column called time. I want to put pull a random 15 flights who time is 30mins from the current time. For instance if the current time is 4:30 I want to pull a random 15 rows who time is 35 mins from now(Which is 4:30) how can I do that. Thanks in advanced! P.S my time format is in 24 hours. One of the times in the database are 1735, I do not have any ":" between numbers Link to comment https://forums.phpfreaks.com/topic/191718-mysql-and-time-query/ Share on other sites More sharing options...
mapleleaf Posted February 11, 2010 Share Posted February 11, 2010 Do it with MYSQL http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html Link to comment https://forums.phpfreaks.com/topic/191718-mysql-and-time-query/#findComment-1010551 Share on other sites More sharing options...
topflight Posted February 11, 2010 Author Share Posted February 11, 2010 can you please like write an example query statement please. Link to comment https://forums.phpfreaks.com/topic/191718-mysql-and-time-query/#findComment-1010559 Share on other sites More sharing options...
topflight Posted February 11, 2010 Author Share Posted February 11, 2010 any other suggestions? Link to comment https://forums.phpfreaks.com/topic/191718-mysql-and-time-query/#findComment-1010566 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.