Timestamp

[Anon]

Hello, I have the following problem:

I`m using a MySQL-database and I want to show the user just the rows between date X and date Y. The date is written in one COL in the datatbase with the UNIX-timestamp format.

The user can choose the start_day,start_month,start_year and end_day,end_month,end_year. I do not realy know how I can write a skript like:

$start=mktime(0,0,1,$start_month,$start_day,$start_year);
$end=(23,59,59,$end_month,$end_day,$end_year);

SELECT * FROM databas WHERE time="(between $start and $end)"

Please help me🙂

Alex

[[deleted]]

SELECT * FROM databas WHERE time="(between $start and $end)"

You want records where the time field is between $start and $end,
so time must be larger than $start, but smaller than $end:

SELECT * FROM databas WHERE time>$start AND time <$end;

[Anon]

BETWEEN will work you just don't need the = sign

SELECT * FROM table WHERE time BETWEEN '$start' AND '$END'

[[deleted]]

And if we're talking timestamps, you don't need the quotes either.

[Anon]

that's true...

bad habit :-)