[PHP] Select two table with DB_DataObject

2006-11-24 Thread Yves Tannier 

Hi,

First, sorry for my bad english ;)

I'm looking for a simple way to provide query with two table like this :

SELECT t1.idperson, t1.lastname FROM table1 t1, table2 t2 WHERE
t1.idperson=t2.idperson AND t1.idperson=2

I try with joinAdd and selectAs but its always complexe query like :

SELECT t1.idperson, t1.lastname FROM table1 t1 INNER JOIN table2 t2 ect...

I can't use query() method because I need to use find() method after
(orderBy, Pager, limit ect...)

Any solution ?

Thanks !
Yves

Re: [PHP] Select two table with DB_DataObject

2006-11-24 Thread Yves Tannier 

2006/11/24, Richard Lynch [EMAIL PROTECTED]:


On Fri, November 24, 2006 10:27 am, Yves Tannier wrote:
 First, sorry for my bad english ;)

 I'm looking for a simple way to provide query with two table like this
 :

 SELECT t1.idperson, t1.lastname FROM table1 t1, table2 t2 WHERE
 t1.idperson=t2.idperson AND t1.idperson=2

 I try with joinAdd and selectAs but its always complexe query like :

 SELECT t1.idperson, t1.lastname FROM table1 t1 INNER JOIN table2 t2
 ect...

 I can't use query() method because I need to use find() method after
 (orderBy, Pager, limit ect...)

I'm not quite sure what DB_DataObject is, or where it comes from...

But wherever that software came from, there is probably a better
list/forum/space to ask this, if nobody here answers.



So sorry. It's a mistake ;)

I've subcribe on php-general@lists.php.net but not on
[EMAIL PROTECTED]

DB_DataObject is a pear package.

bye.
Yves


[EMAIL PROTECTED]