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

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q

want to add a break after a certain amount of characters
i was wondering how to add a break in a blog post after a certain amount of characters... any idea o

Simple MySQL script is not working
Hey guys,

Just familiarizing myself with PHP and MySQL. I am following along in the O'Reilly

Keeping track of php uploads
Hello all.

I was looking at the way PHP handles file uploads.
It seems that PHP uses a tem

session variables not working anymore
hello,
i use sessions to handle authentication within my site. my host has been changing a lot of

Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...

Code: $define_li

Using Microsoft Exchange Server with PHP
Hi,

I wanted to know if its possible to fetch email attachments from the exchange server usin

the problem with str_replace
$str="hahahahahahahahahahahahahaha";
$nn=1;
$str=str_replace('ha','MyGod',$str,$nn);