[SOLVED] selecting date range

[jakebur01]

How do I query a date range? I have a date column in my mysql table. I want to select a range of rows between : Ex. 2007-08-05 through 2007-08-30 .

 

I also would like to have the page that sends the query as a form.. option value that shows all of the available dates, so i can select a from date and a to date.

 

I have never done anything with dates before, I need some help getting going.

[kernelgpf]

$query=mysql_query("select column1,column2 from table1 where date1 <= '$beginningdate' and date1 >= '$enddate'");

 

That should set you on the right track. =]

[jakebur01]

Thanks! What about my selection page where I select my dates. How could I loop through and create option values without displaying the same date twice?

 

 

[jakebur01]

how do I select values from mysql but only display a certain value once. Ex. If I have a column that has 8 "3's", but I only want the 3 displayed one time so that it is not repeated.

[jakebur01]

bump.

[Daukan]

"SELECT DISTINCT date1 FROM table1 WHERE date1 <= '$beginningdate' AND date1 >= '$enddate'  GROUP BY date1"

 

Might work if I have the syntax right.

[jakebur01]

That's not what i'm trying to do. I want to select all of the available dates from a column, but not the same one twice.

 

ex.:

[b]date1 column[/b]
2007-08-05
2007-08-05
2007-08-05
2007-08-05
2007-08-06
2007-08-06
2007-08-08
2007-08-08
2007-08-11
2007-08-12

 

and select only the available dates and not the same one twice. like:

2007-08-05

2007-08-06

2007-08-08

2007-08-11

2007-08-12

[Daukan]

Thats what DISTINCT does.... It will select only one of each date instead of multiples

[jakebur01]

ok thanks.