Getting the Correct Max Date
After I added the dynamic search feature to my “To The Moon” 🚀 Coin Calculator, I noticed that the price of BitCoin (BTC) was not increasing. I knew that it was over USD$9,000 all day, but it was still showing a price just about USD$8,000. When I ran the query in the MySQL database, I noticed that it was pulling back the correct date, but not the correct price. QUERY FAIL!! So, it was off to figure out why my query wasn’t working. To start, I was using the MAX() function to retrieve the latest date added to the table. Continue reading Getting the Correct Max Date