Hi!
I tried this code manually on phpmyadmin and it works but not on my php code. Can somebody please check my code:
$SQL = "create table temp(entdate date, itemcode char(20))";
$result = mysql_query($SQL);
$SQL = "insert into temp
select max(entdate), itemcode
from trn_detl group by itemcode";
$result = mysql_query($SQL);
$SQL = "select a.itemcode, b.item_name, a.qty
from trn_detl as a, items as b, temp as c
where a.itemcode=b.itemcode and a.cust_code=b.cust_code and a.cust_code='$custcode' and b.itemcode=c.itemcode and a.entdate=c.entdate(";
if (sizeof($POST['invselect']) > 0)
{
foreach($POST['invselect'] as $key => $value)
{
$SQL .= " a.itemcode = '$value' OR";
}
} else {
$SQL .= $itemsrch;
}
$SQL = substr($SQL, 0, -2);
$SQL .= " ) ORDER by a.itemcode ";
$result = mysql_query($SQL);
Thanks
