So Do, Some Don't?

[saltious]

Hi.

I have dates stored in a field which appear as (for example) 2009-06-17.

when i run a query to pull all matching dates using CURDATE() function.

only some of the matched records show.

any ideas?

many thanks.

[NogDog]

What is the data type of the field in question?

What is the query you are using?

[saltious]

Hi.

it is of type date. the query i am using is

$query = "SELECT calls.callid, calls.duedate, calls.problem, users.forename, users.surname
FROM calls INNER JOIN
users where calls.userid = users.userid AND calls.completed = 'Open' AND calls.duedate = CURDATE()";

i have just noticed a worrying thing. it is not just this query that does this. it is also for another query i have which goes like this.

$query = "SELECT calls.callid, calls.duedate, calls.problem, users.forename, users.surname
FROM calls INNER JOIN
users where calls.userid = users.userid AND calls.assigned = '$admindude' AND calls.completed = 'Open'";

the $admindude variable is working - i have checked.

there seems to be something going very wrong with my query/larger setup.

any ideas? this really does ruin the whole dam thing.

many thanks

[NogDog]

I would start by doing the query without the date condition, and verify that you are getting all the records you would expect to get without that restriction, as perhaps the problem is elsewhere.