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

Other php-forum

need help with php get
i have a option box that gets filled with dates, but how do i get once the option value has been cli

CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

problem with php server update from mid 2009
Hi,

I have this navigation menu on 2 websites which used to work just fine. After a recent up

Can't find the problem (no error message)!
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm g

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

xml
<?php

echo "<h1>XML Articles</h1>";

$home

contact form - output to page and email
I have the following in my controller:

$message['name'] = htmlentities(strip_tags(trim($_POST

gmdate() - want 1 hr before time
Hi,
I am using php gmdate().
Now I am entering all dates in my dbase using gmdate("Y-m-d

Php WordPress help
I am writing the following code for making a plugin

<?php
header("Content-Type