Daniel J. Choi

How to Remove the Top Border from Drupal Tables

Dev

I’ve been very busy developing a couple projects over the past couple days, but here is a quick little trick to get around one of Drupal’s quirks. If you’re unfamiliar with Drupal, it’s a fantastic CMS (content management system) built on PHP and MySQL. For those blog-savvy among us, it is to general websites what WordPress is to blogs. I use Drupal to get sites up quickly and with great functionality, and I highly recommend it to anyone who is looking to build powerful, custom websites without “re-inventing the wheel.”

Anyway, Drupal has this strange quirk in its source that creates a small grey border on the top of tables inserted in a page’s content.  A quick trip to my inspector revealed how to remove the top border from Drupal tables.  Simply add the following line to your CSS.

body tbody { border-top: none; }

All there is to it. 🙂

Read Next

Export MySQL Query Results to CSV

Dev

If you’re SSH’d into a MySQL server and want to export MySQL query results to CSV (readable by Excel), simply add the below snippet to the end of your query.

INTO OUTFILE '/tmp/results.csv' 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' 
LINES TERMINATED BY '\n'

Note that ‘/tmp/results.csv’ in the code above should correspond to a writeable destination, and the file can’t already exist.

How to Wrap Text in a jQuery Mobile List

Dev

I’ve been doing some development in jQuery Mobile, and though it’s still in Alpha, it’s a great library. That said, there are still some serious bugs in it and some other less than ideal things happening. In any case, working with jQuery Mobile has certainly helped my debugging skills along.  🙂  One of the toughest issues that almost had me pulling out my hair was figuring out how to wrap text in a jQuery Mobile list.  Read on for the fix.

Continue reading

Office 2007 MIME Types

Dev

Here’s a list of MIME Types for Office 2007 files (those pesky files extensions that end with an x). Useful for file type checking in web applications and the like.

  • .docm – application/vnd.ms-word.document.macroEnabled.12
  • .docx – application/vnd.openxmlformats-officedocument.wordprocessingml.document
  • .dotm – application/vnd.ms-word.template.macroEnabled.12
  • .dotx – application/vnd.openxmlformats-officedocument.wordprocessingml.template
  • .potm – application/vnd.ms-powerpoint.template.macroEnabled.12
  • .potx – application/vnd.openxmlformats-officedocument.presentationml.template
  • .ppam – application/vnd.ms-powerpoint.addin.macroEnabled.12
  • .ppsm – application/vnd.ms-powerpoint.slideshow.macroEnabled.12
  • .ppsx – application/vnd.openxmlformats-officedocument.presentationml.slideshow
  • .pptm – application/vnd.ms-powerpoint.presentation.macroEnabled.12
  • .pptx – application/vnd.openxmlformats-officedocument.presentationml.presentation
  • .xlam – application/vnd.ms-excel.addin.macroEnabled.12
  • .xlsb – application/vnd.ms-excel.sheet.binary.macroEnabled.12
  • .xlsm – application/vnd.ms-excel.sheet.macroEnabled.12
  • .xlsx – application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
  • .xltm – application/vnd.ms-excel.template.macroEnabled.12
  • .xltx – application/vnd.openxmlformats-officedocument.spreadsheetml.template
© 2023 Daniel J. Choi

Sliding Sidebar

My friends call me Dan.

Currently, building Recca.

Previously, co-founder @ Plastiq.

Recent Posts

Categories