I have two tables
StatesTable CitiesTable
StateID(char) RunningCountID (int)
State (varchar) StateID (char)
City (varchar)
Both are innodb tables, with CitiesTable having a
foreign key referencing StatesTable.StateID
Basically my first step here is to have some type of
print out:
New York New York
Hastings on the Hudson
Elmira
California Los Angeles
Santa Barbara
Riverside
Now I select both tables all fields, no reason to do a
join since the foreign key is in place. Maybe that's
wrong. Anyway the do line up correctly
but it's more like
New York New York
New York Hastings on the Hudson
New York Elmira
So maybe that's the way it will print on a query
unless formatted.
That leads me to my second question, somewhat client
side, so I can take it somewhere else if it's wrongly
posted here.
I have 1 menu pull down and one list field next to it.
After I select some state from the pull down I want
the associated cities in the list. Now I realize that
this has something to do with a variable being passed.
At the same time I'm wondering if that can be done via
a SQL statement.
Sorry and thanks !
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
