Hi,
I have two table:
mysql> select * from hotel limit 10
-> ;
+----+--------------------+
| id | hotelname |
+----+--------------------+
| 1 | Adams Beach |
| 2 | Aegean Village |
| 3 | Angela |
| 4 | App. in Ayja |
| 5 | Apt Alfaga |
| 6 | Apt. Central Playa |
| 7 | Arabia Beach |
| 8 | Asterias Beach |
| 9 | Baron |
| 10 | Bel Air |
+----+--------------------+
and travel
+-----------------+
| nome_hotel |
+-----------------+
| Vol seul |
| Carina |
| Relax |
| Mistral |
| Esperides Beach |
| Vol seul |
| Angela |
| Marmari Beach |
| Summer Palace |
| Aegean Village |
+-----------------+
What I want to do is replace the nome_hotel field with the ids of the
hotel table for names that match the hotel.hotelname in the
travel.nome_hotel. How do I do this.
TIA
Adrian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
