I have a complex sql query with a self-join that returns 2 variables of the same name. using the variable name in odbc_result() always returns the first instance. Is there any way that I can retrieve the second instance? Thanks Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]