@cfoley

maybe not a bad idea,have to look into those patterns, but it's too late now to rewrite the software and make it use those patterns. Either way, git supports and does what i want it to do, so for now i will try this approach .

yeah thought so , the table will be relatively big(10 000 - 100 000 rows), but the users are limited to 10-20 max images.so they can't execute more than 10-20 queries. and this specific query will not be executed very frequently this just changes the order weights field used to order the images the way the user wants.

Dormilich, on 11 May 2012 - 01:03 AM, said:

no it doesn't, never said that when you just declare the constr. private this turns the class into a singleton.

private constructors are used if you want to do a singleton pattern.

class smt
{
  private static $instance;

  private function __construct() {}

  public static function get_instance(){
  {
    if(!self::$instance)
      self::$instance = new smt();
    return self::$instance;
  }
}

P.S implementations may vary, but the idea is to have only one instance of a given class.

lifesaver, i didn't know bluefish runs on windows too
10x man