PinoyTech.org

CodeIgniter, Kohana, Mootools, jQuery and CSS

How to do Multiple SQL Inserts

Posted by teejay on November 2, 2009

Using multiple insert queries almost always slip my mind when developing applications. If you are like me, we all need some reminder in some way or another.

Continue reading How to do Multiple SQL Inserts

 

Hierarchical Data in a Relational Database

Posted by teejay on March 10, 2009

A Google Search would produce "30,800,000". There are quite a few people looking for a solution to hierarchical data queries.

I, myself have been looking through it for a while and ended up using the The Adjacency List Model due to the need of my data to be updated once in a while.

Continue reading Hierarchical Data in a Relational Database