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

Your Answer:

Login to answer

Other forums

Looking for help on using joining mysql tables and php....
Does anyone have any good links to references on how to pull mysql data, through joining tables and

Comma seperated implode & modifying returned string.
I have a PHP post form that posts up to 4 variables. I need whatever variables are passed to be comb

Material Issuing for receiving batch
Dear All experts in MM/ PP,

Material issuing from main stores to factory is currently usi

php code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat

Prevention Help
How can I use PHP or any other language (feel free to move this thread) to prevent users doing scree

Help with Password Encoding/Decoding?
Trying to design a "change password" tool. On my signup code I'm using base64_encode, now

Something like an INI editor or a DelimitedText-Editor
Hi all,

Am very, very, very new to PHP and not sure if I should be posting this to a Javascri

How many users online in the last 24-hours using time()?
I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

Displaying Site Logo/Icon on a Title tag
really need some help out here. I want to insert a Logo/Icon just like the one close to the "PH