> There isn't the field table_name.ID_city!!! because you didn't ask for it. You asked for: table_name.name table_city.ID table_city.city
-----Original Message----- From: Carlo Loiudice [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 4:02 PM To: PHP DB Subject: [PHP-DB] JOIN operations Hi, I'm preforming a join between 2 Mysql tables in this way: table_name: ID,name,ID_city table_city: ID,city when I query this: "SELECT table_name.name,table_city.ID,table_city.city FROM table_name,table_city WHERE table_name.ID_city=table_city.ID" The result is a new table with this fields: result_table: name,city. There isn't the field table_name.ID_city!!! Here's the question: I need also this field ID_city because there's a function that builds a list box with all the cities, and search for a html hidden input named ID_city (like the table field) to eventually highlight that entry. can someone help me? is there a way to select also the ID_city field without break the join mechanism ? Carlo ______________________________________________________________________ Abbonati a Yahoo! ADSL con Atlanet! Naviga su Internet ad alta velocitą, e senza limiti di tempo! Per saperne di pił vai alla pagina http://adsl.yahoo.it -- 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] -- 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]