php/mysql and dates

[Bob]

This little date formating problem is holding me up!

Here is the sql query string.

.....

WHERE
(`work_orders`.`date_closed` > $ > $start_date)
AND (`work_orders`.`date_closed` < $end_date)
ORDER BY
(`work_orders`.`date_closed`)";

The dates are in the 2005-05-16 format already.
A typical start_date might be: 2005-05-11 with end_date of 2005-05-16

I get no results returned even though there are records that meet that
criteria.

help please.

bob

[Oli Filth]

Bob wrote:

This little date formating problem is holding me up!

Here is the sql query string.

....

WHERE
(`work_orders`.`date_closed` > $ > $start_date) ^
^
Are you sure you meant this dollar sign to be here?
AND (`work_orders`.`date_closed` < $end_date)
ORDER BY
(`work_orders`.`date_closed`)";

The dates are in the 2005-05-16 format already.
A typical start_date might be: 2005-05-11 with end_date of 2005-05-16

Dates and times need to be delimited with single quotes in SQL queries.

If a MySQL call doesn't work, either turn on mysql.trace_mode the
directive, or echo a mysql_error() call to find out what the problem
is!!

--
Oli

[Bob]

I don't know how that $ got in there, it's not in the code. And it
doesn't work with out the $ either. The sql string is as follows:
SELECT `work_orders`.`Work_Order_Number`, `work_orders`.`Date_Opened`,
`customers`.`last_name`, `work_orders`.`Due_date`,
`work_orders`.`priority`, `work_orders`.`Part_Number`,
`work_orders`.`Qty`, `work_orders`.`Qty_Shipped`,
`work_orders`.`Value`, `part_numbers`.`part_number`,
`part_numbers`.`part_number_sub`, `part_numbers`.`description`,
`part_numbers`.`qty_in_inventory` FROM `customers`, `work_orders`,
`part_numbers` WHERE (`work_orders`.`date_closed` > 2005-05-01) AND
(`work_orders`.`date_closed` < 2005-05-17)
which returns:

Number of work orders in database= 0

[Oli Filth]

Bob wrote:

I don't know how that $ got in there, it's not in the code. And it
doesn't work with out the $ either. The sql string is as follows:
SELECT `work_orders`.`Work_Order_Number`, `work_orders`.`Date_Opened`, `customers`.`last_name`, `work_orders`.`Due_date`,
`work_orders`.`priority`, `work_orders`.`Part_Number`,
`work_orders`.`Qty`, `work_orders`.`Qty_Shipped`,
`work_orders`.`Value`, `part_numbers`.`part_number`,
`part_numbers`.`part_number_sub`, `part_numbers`.`description`,
`part_numbers`.`qty_in_inventory` FROM `customers`, `work_orders`,
`part_numbers` WHERE (`work_orders`.`date_closed` > 2005-05-01) AND
(`work_orders`.`date_closed` < 2005-05-17)

Did you read the second half of my previous comment??

--
Oli

[Bob]

Yes, I did. But I'll have to read up on those mysql commands.
I am not familiar with them.
I was assuming the sql query was working, but that I was not
structuring the query the correctly.

Oli Filth wrote:

Bob wrote:

I don't know how that $ got in there, it's not in the code. And it
doesn't work with out the $ either. The sql string is as follows:
SELECT `work_orders`.`Work_Order_Number`,

`work_orders`.`Date_Opened`,

`customers`.`last_name`, `work_orders`.`Due_date`,
`work_orders`.`priority`, `work_orders`.`Part_Number`,
`work_orders`.`Qty`, `work_orders`.`Qty_Shipped`,
`work_orders`.`Value`, `part_numbers`.`part_number`,
`part_numbers`.`part_number_sub`, `part_numbers`.`description`,
`part_numbers`.`qty_in_inventory` FROM `customers`, `work_orders`,
`part_numbers` WHERE (`work_orders`.`date_closed` > 2005-05-01) AND
(`work_orders`.`date_closed` < 2005-05-17)

Did you read the second half of my previous comment??

--
Oli

[Oli Filth]

Bob wrote:

Oli Filth wrote:

Did you read the second half of my previous comment??
Yes, I did. But I'll have to read up on those mysql commands.
I am not familiar with them.

More relevant than that, the bit about having to delimit date strings
in MySQL with single quotes.
I was assuming the sql query was working, but that I was not
structuring the query the correctly.

I can tell you right now, it wasn't correct, because of the date thing.

--
Oli