Thanks for the reply.
I had already done the phpinfo() here on heliohost and on my local server. Here's the result from the PDO section
LOCALLY
pdo_sqlite
PDO Driver for SQLite 3.x enabled
PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.4 2008/12/31 11:17:42 sebastian Exp $
SQLite Library 3.3.7undefined
Heliohost
pdo_sqlite
PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6 2006/01/01 12:50:12 sniper Exp $
SQLite Library 3.2.8
It looks like I'm running a build from 2008, whereas HH is running a build from 2006. So, I guess I'll find another method to escape my strings before INSERT.
Ok, I think I'll just go with this approach instead:
$db= new PDO('sqlite:Escape.sqlite);
$strquote = "Why can't I insert you're escape aren't working?";
$strquote = $db->quote($strquote);
and I'm good to go.