Browse: Home / code

code

Using MySQL to generate daily sales reports with filled gaps

Using MySQL to generate daily sales reports with filled gaps

By Armand Niculescu on August 19, 2009

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.

Posted in | Tagged , , , , | 14 Responses

Javascript animated collapsible panels without any frameworks

Javascript animated collapsible panels without any frameworks

By Armand Niculescu on April 13, 2009

If you need to make collapsible panels that remember their state, but don’t want to use any javascript framework, this tutorial will help you do this with no headaches – and you’ll learn some neat javascript tricks too!

Posted in | Tagged , , , , , , | 29 Responses

AS3 Tutorial: Creating a Slideshow

AS3 Tutorial: Creating a Slideshow

By Armand Niculescu on May 5, 2008

The code is AS3 and the tutorial assumes some general knowledge of flash and actionscript 1 and 2.

Posted in | Tagged , , , , , | 12 Responses

Search and Replace tool for MSSQL

Search and Replace tool for MSSQL

By Armand Niculescu on July 7, 2007

Every now and then I come across some bad practices that needs repairing. This time the “no-no” was in a database tables. I had to change hard-coded links in quite a few tables. Replacing 10,000 absolute URLs spread across the database can be a huge headache, so I decided to work smart, not hard. So [...]

Posted in | Tagged , , , , | 7 Responses