Posted by bigsamurai on 10/14/09 11:33

Thanks. I have included the actual query I was running below.

SELECT ood.ood_watch_officer, ood.ood_start, ood.ood_end, ood.ood_date,
COUNT(ood.ood_date), ood_per.ood_per_no, ood_per.ood_per_name FROM ood,
ood_per
WHERE ood.ood_watch_officer=ood_per.ood_per_no
AND (ood.ood_date BETWEEN '$_POST[date1]' AND
'$_POST[date2]')
ORDER by ood_per.ood_per_name";

Two tables ood and ood_per

• Next in forum: Re: number of entries in a date column
• Prev in forum: Re: Uploading an entire folder?
• Thread view: Re: number of entries in a date column

[Reply to this message]