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?

Did you know?Explore Trending and Topic pages for more stories like this.
Thanks
No comments posted yet

Your Answer:

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

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Create comparison matrix?
I want to create a comparison script for forum software and was wondering is there any tutorial or b

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q

Help with explandable category tree
I have the below query:

SELECT l1.id as lev1_id,l2.id as lev2_id,l3.id as lev3_id,l1.categ

The IE or FF detector
Hello Friends,

Problem of today ( we seek for php help ) as following ,

we know all th

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

onclick problem
I have <input type="text" name="message">
<a href=page2.

include function being weird?
I have a very simple system to grab an IP outputted by a PHP file.. (for a project I have) but it ou

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

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