[SOLVED] making a selection of between and including of dates

[Poddy]

i have this code:

$sql = "select * from `data`  where  `name` LIKE '$name' AND `spot` LIKE '$line' AND `piret` LIKE '$piret' AND `timestamp` BETWEEN '$before' AND '$after' ORDER BY `timestamp` DESC  ";

it works fine, the problem is if i select from dates like 2008-06-11 to 2008-06-25 i get all dates between them, but those with 25 i do not get..

is there any way to get around this? thanks

[br0ken]

I would personally use >= <= rather than between, so something like:

 

$sql = "select * from `data`  where  `name` LIKE '$name' AND `spot` LIKE '$line' AND `piret` LIKE '$piret' AND `timestamp` >= '$before' AND `timestamp` <= '$after' ORDER BY `timestamp` DESC  ";

[PFMaBiSmAd]

BETWEEN is inclusive.

 

If it is not working for you, something is wrong with your values. Show us what echoing $sql looks like with values and show some of your data in your database.

[Poddy]

thanks for the reply but it still dosent display the last day

 

query:

select * from `data` WHERE `timestamp` >= '2008-06-15' AND `timestamp` <= '2008-06-25' ORDER BY `timestamp` DESC

 

result:

  	Edit   	Delete   	101  	4  	fghf  	456  	fghfg  	1  	2008-06-24 17:09:10  	5  	5  	5
Edit 	Delete 	96 	5 	sdfds 	324 	dfgdf 	1 	2008-06-15 17:08:12 	5 	5 	5

[PFMaBiSmAd]

Your timestamp column is a DATETIME data type. Use the mysql DATE() function around it so that only the DATE portion will be used in the comparisons.

[Poddy]

Solved, changed the column to DATE type and added insertion of date in the insert query, which i tried to avoid..

works well now

thanks everyone