$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';";
the error that is returned:
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
so how do I insert my values where I have the primary key store into the database? That primary key is what was I going to use as an identifier as to WHERE I would place my data