You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Code:
mysql_query("INSERT INTO `trans` (id, trans, acctfrom, acctto, date, type, amt, ip) VALUES('', 'x0000000', '".$acctfrom."', '".$acctto."', '".$date."','1', '".$amt."', '".$ip."'") or die(mysql_error());
I don't see it. Please advise.