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

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

PHP Array quick help
I need

$_SESSION{'username'} to be like this:


if $_SESSION['username'] = "gay

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

Help adding strtolower( to my in_array
strtolower i need to add it to this to work, iuno how.

Code: $moderators = array('Admin', 'ba

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

php require help needed
Ok i tried to use the search funtion but the word require is everywhere.

i'm really new to cr

Placing and array within an array then sorting it!
I have a page that runs two large mysql queries and saves the results into arrays, in php I then per

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows

SQL>

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