if (!empty($this->WhereClause)) {
$sqltext.=" WHERE ".$this->WhereClause;
}
+ $sqltext.=" ORDER BY ".$this->UnparseColumn($colnum);
return $sqltext;
}
$this->dbDefault = $DefDB;
$this->dbMain = mysql_connect($this->Provider,$userid,$pw);
mysql_select_db($DefDB,$this->dbMain);
- $this->db =& new dbClass_mysql($this->dbMain);
+ $this->db = new dbClass_mysql($this->dbMain);
if ($this->CheckForError("opening connection")) return false;
return true;
}
$this->Dialect="Oracle";
$this->dbDefault = $user;
$this->dbMain = ocilogon($user,$pw,$sim);
- $this->db =& new dbClass_oci($this->dbMain);
+ $this->db = new dbClass_oci($this->dbMain);
if ($this->CheckForError("opening connection")) return false;
$this->RunActionQuery("alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS'");
return true;
$this->LastErrorMsg="Error while connecting to ".$servername;
return false;
}
- $this->db =& new dbClass_mssql($this->dbMain);
+ $this->db = new dbClass_mssql($this->dbMain);
mssql_select_db($DefDB,$this->dbMain);
return true;
}