DB fetchs don't work OK

From: Date: Sat, 28 Dec 2002 11:58:37 +0000
Subject: DB fetchs don't work OK
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-3093@lists.php.net to get a copy of this message
I have a problem when I try to fetch from a query with unions and fields from the different tables that have the same name. For example: SELECT tab1.name,tab2.name,tab2.uni FROM tab1,tab2 WHERE tab1.cod=tab2.cod If I use fetchRow(DB_FETCHMODE_ASSOC) DB doen't know how to distinguish between tab1.name and tab2.name, because it the fetches are only with the column name and not the table name as well. Would this be a bug in my version of PEAR? I'm using PHP 4.1.2 with the version of PEAR that came with this version of PHP. -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------

« previous php.pear.general (#3093) next »