Simple MySQL query...


Posted on 16th Feb 2014 07:03 pm by admin

Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ago? Also, what type of field will I need to create in the database? date/time or just time? And, what type of date/time function would I use to insert the data? would I just use UNIX Timestamp?

Thanks

No comments posted yet

Your Answer:

Login to answer
68 Like 14 Dislike
Previous forums Next forums
Other forums

Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

Opening Multiple Files/Links in Order.
I want to open links in order/one-by-one and check each for a specific string.

Example:
I

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span

Must-Know Topics of PHP
Can you guys list the must-know topics of PHP. I am still a learner and I am trying to cover most of

standard ALV application toolbar, into custom report....
HI,

I have a question regarding displaying standard ALV menu path and application toolbar

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash