Database

Curse of the Redesign: Handling Existing Content

January 23, 2018
My work, Web Development
Database, Web Development

As I spoke about in the previous post about redesigns my work generally focuses on clients who have existing sites that need to be moved to a new Content Management System and have a new design applied to them. Whilst this can have it’s advantages for design work by allowing the front end developers far more freedom with markup it has some challenges for the backend. Discovery # Every database I have received have been from a different CMS, some have been MySQL and some have been Microsoft SQL database but all have required some discovery. ...

Drupal 6 num_rows

March 7, 2010
Uncategorized
Database, Drupal, Web Development

I’ve been working on a site powered by Drupal and needed to find the number of rows a database query returned. Simple enough and quite common procedure. But, the Drupal database API no longer offers the db_num_rows() function. I had a quick Google around and the answered seemed to be to run the query twice but the second time using a count query. Two calls to the database when only one is necessary? ...