Hi Scott:
On Tue, Jul 02, 2002 at 11:08:30AM -0400, Scott Fletcher wrote:
> That's a great idea!
Good.
> I have one little problem. If I do the odbc_fetch_array then I
> can't include two tables because of the two of the same column name.
In your query, rename the fields using an AS statement.
SELECT Tbl1.ID AS ID1, Tbl2.ID AS ID2 FROM...
Then, in your data array, refer to them as 'ID1' and 'ID2.' You can name
the fields nearly anything you want (as long as you're not using a
reserved word the database needs for internal use).
--Dan
--
PHP classes that make web design easier
SQL Solution | Layout Solution | Form Solution
sqlsolution.info | layoutsolution.info | formsolution.info
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
