subject:"\[PHP\-DB\] SQL Join problem \(Firebird\)"

Re: [PHP-DB] SQL Join problem (Firebird)

2003-09-03 Thread Sean Burlington

Evan Morris wrote: 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 result

[PHP-DB] SQL Join problem (Firebird)

2003-09-02 Thread Evan Morris

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 ($r