I'm on shared hosting, so I can't do that.
I'm quoting like this:
return $this->fetchAll(
$this->select()
->from($this->_name)
->where($this->getAdapter()->quoteInto($this->_name . '.id IN (?)', $ids,
Zend_Db::INT_TYPE))
->order('date DESC')
);
where $ids is array of table primary keys.
Regards,
Saša Stamenković
On Thu, May 20, 2010 at 3:02 PM, Thomas D. <[email protected]> wrote:
> Hi,
>
> Саша Стаменковић wrote:
> > I don't know how to monitor mysqld, maybe get connection
> > from adapter with getConnection() and then retreive it from there and
> log?
>
> No. Monitoring your mysqld has nothing to do with PHP.
>
> If you are on Unix or FreeBSD, you would use a tool like "mtop".
> If you are on Windows you can use the MySQL Administrator from mysql.org.
>
>
> P.s.: When you are quoting, how do you do that?
> $table = new MyZendTable();
> $adapter = $table->getAdapter();
>
> $quoted_string = $adapter->quote(...);
>
> If you are using "getConnection()" you will create an additional
> connection/object and won't use the existing one.
> Maybe this is your problem...
>
>
> --
> Regards,
> Thomas
>
>
>