Dive into the archives.

• Import CSV data

  How do i import a csv file into MySQL?
  FTP the csv file up to your web root, and login the PHPMyAdmin. Drop this in the ‘SQL’ box and tweak the table / field names.
  LOAD DATA LOCAL INFILE ‘/importfile.csv’ INTO TABLE table_name FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’ (field1, filed2, field3);
  Browse your table.
  Drink […]

  Posted on Oct 14.07 to Code   

• Optimisation Rarely Gets Better Than This …

  I’m not really one to blow my own trumpet, but these results are so good I simply can’t resist.
  Four weeks ago at the beginning of September, I launched a new web-based application - http://votewise.co.uk. The site provides election candidates a (free) platform to post there campaign manifesto, engage with voters and harvest feedback on various […]

  Posted on Oct 03.07 to Code   

• PHPList Hack

  About this time last year I wrote a hack for PHPList, an open-source PHP/MySQL HTML email engine and mailing list manager. The hack allows the super admin to assign HTML email template permissions to other admins, effectively turning a single site application into a multi-site / multi-admin application.
  The original hack is here:
  http://forums.phplist.com/viewtopic.php?t=4928&highlight=template+permissions
  I’ve have loads of […]

  Posted on Apr 28.07 to Code