ok this is what i want to do
i have 2 tables 1 is information about a postion and
the second is org info eg
table 1
--------------------------------------------------------
| Continent | Country | Postion | Name | Ward | ORG_ID
|
--------------------------------------------------------
| 1 | 2 | 3 | Name | Ward | 1
|
--------------------------------------------------------
table 2
--------------------
| ORG_ID | ORG_Tag |
--------------------
| 1 | Org 1 |
| 2 | Org 2 |
| 3 | Org 3 |
--------------------
now what i want is when a user enters
2 3 4 Name Ward ORG 2
i want to user a single INSERT Command to enter this
into the database
2 3 4 Name Ward 2
by cross referencing the ORG_Tag with the ORG_ID
___________________________________________________________ALL-NEW Yahoo! Messenger -
sooooo many all-new ways to express yourself http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
