I'm having one last hiccup with my implementation of history. Everything about it works just fine except for the fact that it appears that only one entry can be stored in my SQL table, permanently.
If the table is empty and I purchase or sell a stock then the information is stored correctly and outputs to my history page just like it should. However, if I make any other purchases or sales no new rows are added to the table. The original entry just stays there. If I delete that entry to buy or sell again then that new history log will be saved to the table but will also be the only one there. Any subsequent buys or sells aren't stored in the SQL table.
Why am I only able to input 1 row? I'm using the same SQL insert language that I've used for my other tables. Below is my code and table structure:
query("INSERT INTO history (id, transaction, date, symbol, shares, [![enter image description here]]price) VALUES(?, ?, now(), ?, ?, ?)", $id, $sell, $symbol, $shares, $price);