Category Archives: MySQL

Disabling Drupal Modules via your Database

Due to the occasional small (or large) fluke, your entire Drupal website can become inaccessible because of a module.  This is how you solve the problem: disable the specific module by altering values in your Drupal database. In our case, we'll use phpMyAdmin, but you can use whatever utility you prefer for database manipulation.  So,…
Read more

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