Monthly Archives: December 2007

Get the ID generated from the previous INSERT opereration

With the PHP function mysql_insert_id( ), you can obtain the previous index generated from an insert operation. The need for this capability came about when we were generating a MySQL database for invoice storage.  Our database contains an INVOICE table for customer billing information, and an INV_ITEM table for individual items that are included in…
Read more

PHP 4.3: Remove a specific key from an array

PHP 5+ provides the built-in function array_diff_key() which can be used to delete a certain key from an array.  Although I'm not proud of it, some of our customers' sites are still running versions prior to PHP 5.  This is how we delete a specific key from an array in PHP 4+ (4.3).  Let's say…
Read more

Drupal: Custom Latest Posts

We're currently developing a Drupal community website for an up-and-coming society. On the community front page we wanted to display a list of the most recent forum posts. This can easily be accomplished using the Drupal API, and the forum_block() function, with the parameters ‘view', and the 0 for most active posts, and 1 for…
Read more

Our New Site is LIVE

As you might have noticed, we just performed a total overhaul of our site. The navigation and layout should be more-or-less the same, but the overall site aesthetic is dramatically different, and should provide a better platform for future expansion. We plan on adding new capabilities including upgrading our portfolio, which is currently unavailable, but…
Read more