Hi all
Say you have two tables, TABLE1 and TABLE2. Each table contains (amongst
others) a field called SOMEVALUE
Now, in TABLE1 SOMEVALUE contains "string1", but in TABLE2 SOMEVALUE
contains "string2".
Now you join these tables (on SOMEOTHERVALUE) and you loop through the
results set:
while ($row = ibase_fetch_object($sth)) {
echo "$row -> SOMEVALUE<br>";
};
This only echoes the value of SOMEVALUE last referred to in your SQL
statement (obviously, because it has no way of differentiating between the
two versions of SOMEVALUE).
However, it does not work to do
echo "$row->TABLE1.SOMEVALUE<br>";
This has unexpected results (it echoes the literal text SOMEVALUE).
So, what's the answer? Simply rename one of the SOMEVALUE fields in the
database? Or is there a way to differentiate them at the PHP level?
I know one can alias them in the SQL statement itself, like "SELECT
t1.SOMEVALUE, t1.SOMEOTHERVALUE, t2.SOMEVALUE, t2.SOMEOTHERVALUE from TABLE1
t1 JOIN TABLE2 t2 ON t1.SOMEOTHERVALUE = t2.SOMEOTHERVALUE"
However, you cannot go
echo "$row->t1.SOMEVALUE<br>"
since this again echoes the literal text SOMEVALUE (ie, the field name).
Any and all help appreciated.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
