MySQL issues
I modified the search query to apply proper date formatting as well as sort in ASC order:
SELECT id, date_format(motion.stamp, '%m/%d/%Y' )as date, call_order, case_number, type, plantiff, plantiff_attorney, defendant, defendant_attorney, location, cancellation
FROM motion
WHERE stamp >= NOW() And case_number is null
ORDER BY stamp ASC, call_order ASC
When I test this query in Dreamweaver, it works perfectly. However when I test it live:
motion_open_dates.php
The dates do not appear! What might be causing this?