Hi Ruprecht, > > SELECT Kunden.*, City.name, City.vorwahl FROM Kunden LEFT JOIN City > > USING (zipcode) > > I'm understanding you this is a way for designing the sql-statement. Yes. > My customer want that they have inserted the city after typing in the > zipcode in the zipfield. The city should be searched in a database and > inserted in the field city automaticly. > I think the only way is to do that with some ajax-code combined with a > short phpscript. > > Actually I have these codes, but the automatic inserting fails, I don't > know why. <code snipped> Dynamically changing the fields, I'm afraid I can't help. You would be better trying a list dedicated to ajax. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php