Tag: mysql

Using MySQL to generate daily sales reports with filled gaps

I was surprised to see that there’s not a great deal of info on the web on how to do a proper daily report – one that doesn’t have any gaps when data is missing. In this post I’ll try to quide you through building such a report using MySQL and PHP for a nice chart.

A very fast introduction on Mysql triggers

I started to work on a pet project for tracking deleted/pending domains and after starting development I was facing a big problem: How to do the data validation directly from MySQL ?