prakash2000
Technical User
Dear All,
Every week im preparing weekly report based on the following query. last one month its worked properly but this week its not working.
my DB fidld "DateTime" Varchar type.it capture following format date and times "January 31, 2010, 1:50:05 pm"
$sqlQuery="SELECT Center,count(*)as rec FROM res_DB where DateTime BETWEEN '".$st_date."%' and '".$sto_date."%' GROUP BY Center";
details
-------
st_date - starting week date
sto_date - End of the week
pl. help me where is the problem.
thanks in advance.
prakash
Every week im preparing weekly report based on the following query. last one month its worked properly but this week its not working.
my DB fidld "DateTime" Varchar type.it capture following format date and times "January 31, 2010, 1:50:05 pm"
$sqlQuery="SELECT Center,count(*)as rec FROM res_DB where DateTime BETWEEN '".$st_date."%' and '".$sto_date."%' GROUP BY Center";
details
-------
st_date - starting week date
sto_date - End of the week
pl. help me where is the problem.
thanks in advance.
prakash