query problem with data

[Lod]

I have a problem about a query.

I have a table with 4 column.
1) id (INT)
2) Special_Date (VARCHAR)
3) date_start (DATE)
4) date_finish (DATE)

In a page i use the function date() to have the date of today in a varible like this:

$today = date("Y-m-d");

I must create a query which select if the date of today is beteween the date_start and the date_finish.

Anyone can help me?

[tekky]

I bet you didnt look here.....

[Lod]

Originally posted by tekky
I bet you didnt look here.....

I'm seeing it now...

but is not the same case.

I need to have a query that select the records from my table where the date of today is included between date_start and date_finish..

anyone can help me?

[Lod]

🙁

i can't continue if i don't solve this problem 🙁

[tekky]

Originally posted by Lod
I'm seeing it now...

but is not the same case.

I need to have a query that select the records from my table where the date of today is included between date_start and date_finish..

anyone can help me?

if you scrolled down and looked... there is several threads thats used

SELECT * FROM TABLE WHERE COLUMN BETWEEN VALUE1 AND VALUE2

how can that not be used to solve your problem?

[Lod]

tnx a lot...it's the right query!

[tekky]

Originally posted by Lod
tnx a lot...it's the right query!

you're welcome, next time follow the the help given and actually READ on your own

its not unlikely that people refuse to help those who wont attempt to help themselves... especially when given everything they need to read....