Has un
echo para ver el string sql que le llega a mysql
Código PHP:
Ver original<?php
/**
* observa cómo se envían las fechas: BETWEEN '...' AND '...'
*/
echo $sql = "SELECT
lading_control.outputcontrol AS oc, lading_control.outputdate AS od,
entry_control.control_num AS cnum, entry_control.id_control AS idc,
entry_control.autodeclara AS ad, entry_control.fecha AS fe,
entry_control.id_carrier AS idca, entry_control.id_cliente AS idcli,
entry_control.id_destino AS iddes, entry_control.id_location AS idloc
from lading_control, entry_control
WHERE lading_control.outputcontrol=entry_control.control_num
AND entry_control.id_cliente='$customer'
AND lading_control.outputdate
BETWEEN '$calendar' AND '$calendar1'
ORDER BY lading_control.id_lading DESC";
//$rsbill = mysql_query($sql) or die(mysql_error());
?>