DB fetchs don't work OK
| From: | Martin Marques | 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
-----------------------------------------------------------------