早口言葉#4

A quirkily tricky twister of tongues this time: 「竹垣に竹立てかけた」

local sqlite db in android

If you want to include an existing SQLite database in an Android app, but all the tutorials seem to be telling you how to create one at runtime, go here:

http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/

Easy-to-understand and thorough tutorial on using your own database. Something, I might add, that should really have its on section on the Android Dev site.

BTW sorry for the total lack of puns in the post title. I shall do better in future, I promise.

aaaiiiIEeee 7/8 bug

There seems to be a weird form submission bug in old versions of Internet Explorer (i.e.* 8 or earlier).

inkscape considered harmful

by me, to my own sanity.

installing Native American Tribe

If you need to install Apache and, like me, are still running Vista, GO HERE NOW:

How to Install Apache 2.2 on Windows Vista

It is a very simply-written guide to a fairly complex process.

spot the mys(ql)take

Spot the mistake time again:

mysql_query(
  "INSERT INTO users (username, password) ↲
    VALUES($user, $pass)", 
  $database
);