"Select * from table where dateadded>$date" problem.

jason20

I can't get it to work properly. I have 2 dates. 1st one, i try to select the date from 2 days ago and the 2nd date is the date of the application. I have stored the date of the application in the database named dateadded.

The following:

$date=date("Y-m-d")-2 days; 
sql="SELECT * FROM table WHERE dateadded>$date";

So i try to select everything from 2 days ago.

Thanks for any help.

stolzyboy

try

<?
$today = getdate(); 
$date = $today['mday'];
$date = $date - 2;
sql="SELECT * FROM table WHERE dateadded > $date";

JasonL

Thanks for your help.

But, i have 2 records.
1st with date "4-02-03"
2nd with date "30-01-03"

Now if i execute the script today then it should only display the 1st record because that's within 2 days. But it displays both records with your code. 🙁

stolzyboy

hmmm....how are you storing the date in the database, one field, three fields, date(), ???

JasonL

One field named 'dateadded'.

And i insert the date with the following:

$date = date('j-m-y');

JasonL

Any thoughts?

stolzyboy

that's a negative Ghostrider, the pattern is full

anyway, no i can't think of any i usually have three fields to use date, probably inefficient, but it is easier for me to work with

JasonL

Aight, thanks.

I figured it out with 'BETWEEN'.

stolzyboy

oh for dumb, i have helped someone else out with dates with between, funny how sometimes ideas skip your mind unless you are actually working on the problem, duh, lol