Search results

  1. M

    splitting data in a mysql table

    i have a table with date / time stored in one field, like 01-01-2008 05:46:13 how can i split this into two seperate date / time fields. Or, if that can't be done, how can i delete the time part? cheers Matt
  2. M

    Script to auto-generate a website

    hi all, having a blank brain moment! i used to use a script to create sites that had a news page, video page, article page etc. All you did was add a few keywords, and it generated the site, and automatically updated it every day. add a few adsense blocks or whatever, bit of advertising and...
  3. M

    How can I record mysql queries in a log file

    Does anyone know of any software that I can use to record mysql queries as they are run? Basically, I've got wpmu running locally on my laptop, and want to record what queries are used to create a new blog, so i can write a script to streamline the process. Cheers
  4. M

    How do blog companies like Wordpress and Blogger make money?

    How do blog companies like Wordpress and Blogger make money? Wordpress and Blogger must host millions of blogs, using lots of resources and bandwidth... So how do they pay for it? There must be lots of other dedicated blog hosting sites that need to have revenue to run too. I've got a good...
  5. M

    Quick bit of help with a sql query

    Hi all, I need some help with a mysql query... i have a db full of records like: id - searchterm - location - date 1 - ipod - us - 24/11/2007 2 - iphone - us - 24/11/2007 3 - - us - 24/11/2007 The id column is an auto-increment, so increases everytime a search is completed and...
  6. M

    PR4 domain for sale: flood-defence-systems.com

    Domain: flood-defence-systems.com PR: PR4 - checked at seologs.com Registered at: Dynadot Price: $70 ono Would rather only transfer this to another Dynadot account. Payment by Paypal only. As noted above, I have checked the PR at seologs.com, but you should carry out your own checks too. PM...
  7. M

    geo-location and search spiders

    If I have a site which sends visitors to index.php/uk or index.php/us depending on geo-location, what will the search engine spiders spider? How do the spiders know about geo-locations? I’d prefer to have a single index page, but have some php to change offers depending on location...
  8. M

    Favorite beer.

    Give me a bottle of San Miguel any minute of the day. However... Leffe is the drink of champions. What's your tipple?
  9. M

    Can a mod put a big fat nsfw on a thread for the sake of people who are at work?

    This one... http://www.wickedfire.com/shooting-shit/12669-some-fuck-pointed-his-domain-my-site.html?highlight=domain+redirect cheers.
  10. M

    Does anyone actually like ClearType on IE7

    Well, come on, own up then... does anyone actually like ClearType on IE7? Personally I hate it. It makes my eyes feel like I've eaten some cubensis mushrooms (which is no bad thing), but there's a time and a place for that behaviour. There's no need for that when you're trying to design a...
  11. M

    mysql gui admin tool

    I'm looking for a mysql gui admin tool.. I've found Navicat which looks good. Does anyone have any other favorites or advice?