Named variables in sql query

Try this one, no time to test right now busy.
You need to pass in the start and end strings for the dates to search.

PHP Code:

$sql = 'SELECT
MONTHNAME (itd.DateOfshippment) AS Month
,COUNT(itm.Name) AS Operations
FROM ImportsMaster itm
INNER JOIN ImportsDetails itd on itm.ID  = itd.IDMSTR
WHERE itd.Market IS NOT NULL
AND itm.Trader LIKE "%TEXT%"
AND itd.DateOfshippment between "{$start}" and "{$end}"
GROUP BY MONTH(itd.DateOfshippment);'; 


What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )