Oracle/PHP Error

[NeedHelp]

I developed a program and it worked fine. Some guys changed the tables I was using a little and now I get this error:

Warning: Ora_Parse failed (ORA-00933: SQL command not properly ended -- while processing OCI function OPARSE) in <filename> on line 106
Oracle code - ORA-00933: SQL command not properly ended -- while processing OCI function OPARSE

Anyone know what this means? Why would a table change cause this error even though I've updated the SQL inside the PHP?

[TkTech]

Want to show us the query you have in php and the layout of your table?

[NeedHelp]

Sure

PHP Code:


$query = "SELECT SUM(AMOUNT) "
."FROM table_inc_trp "
."WHERE ID_NUMBER='$id[$i]' "
."AND NAME='$account' "
."AND date >= '01-JAN-$tYear' "
."AND ACCOUNTING_DATE LIKE '$_mnt[$m]'"; 


[Lop]

I bet one of the fields you have there has a character that needs to be escaped and it is causing your query to end.