Not filtering Results

[liamloveslearning]

Hi everyone, I need to select rows from my database where intradelete = 1 and between 2 sets of dates only its selecting everything, the intradelete = 1 doesnt seem to be working, can anybody see why? heres my query

 

SELECT *
FROM worksorders
WHERE worksorders.intradelete = 1 BETWEEN '$startdate' AND '$enddate' 

 

and heres my startdates

<?php $startdate = date('Y-m-d', strtotime ("last Sunday"));
$enddate = date('Y-m-d', strtotime ("next Friday"));

?>

[-Karl-]

SELECT *
FROM worksorders
WHERE worksorders.intradelete = '1' BETWEEN '$startdate' AND '$enddate' 

 

Maybe?

[liamloveslearning]

No luck, its strange

[liamloveslearning]

Ive tried removing the filter between dates and just selecting where intradelete = 1 but its still not working, i really cant understand it

[kenrbnsn]

What field is between those dates? You're not telling MySQL that.

 

ELECT *
FROM worksorders
WHERE worksorders.intradelete = 1 and somefield BETWEEN '$startdate' AND '$enddate' 

 

Ken

[liamloveslearning]

Hi Ken,

 

I want it to select ALL records between them dates, where intradelete=1

[liamloveslearning]

Nevermind sorry its clicked! thanks ken, excuse my stupidity!