WHERE statement error
Posted: Tue Dec 26, 2006 7:24 pm
i have another mysql question.
the error that is returned:
I made sure that I inserted '$var' on my php variable in the WHERE part of the statement, however I am still a little lost as to what is wrong with it. Any ideas??? thanks
Code: Select all
$mysql_tickname_insert="INSERT INTO curldata VALUES ('','','$this->dividend','$this->curass','$this->multiplier','$this->bookval','$this->long_term_debt','$this->liabilities') WHERE ticker='$this->ticker';";Error number: 1064 Message: 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 'WHERE ticker=''' at line 1
I made sure that I inserted '$var' on my php variable in the WHERE part of the statement, however I am still a little lost as to what is wrong with it. Any ideas??? thanks