[RESOLVED] Need help with error please

[SJones]

Hello, I have been at this for almost two days now, can someone help find the error in this code. You can see it if you Click Here
$query = 'SELECT customers_name , customers_street_address , customers_city , customers_postcode , customers_state , customers_telephone , customers_email_address , date_purchased '
. ' FROM orders '
. ' WHERE date_purchased > '".$POST['start_year']."-".$POST['start_month']."-".$POST['start_day']." 00:00:00' AND date_purchased < '".$POST['end_year']."-".$POST['end_month']."-".$POST['end_day']." 00:00:00' LIMIT 0, 30';

[devinemke]

i suggest a different approach:

$start = $_POST['start_year'] . '-' . $_POST['start_month'] . '-' . $_POST['start_day'];
$end = $_POST['end_year'] . '-' . $_POST['end_month'] . '-' . $_POST['end_day'];

$query = "SELECT * FROM orders WHERE date_purchased BETWEEN '$start' AND '$end' LIMIT 0, 30";

[SJones]

Thank you (That worked great) - YES!