Hi,
I have the following tables:
Country:
id | int(5) | | PRI | NULL | auto_increment |
country | varchar(35) | | MUL | | |
contid | int(5)
City:
id | int(5) | | PRI | NULL | auto_increment |
city | varchar(35) | | MUL | | |
countryid | int(5) |
Special:
id int(5)
contid int(5)
cityid int(5)
I am using php for this project. Right now it is related to mysql. What
I want is to display the names of the countries and cities from the
Special table instead of the ids. What would be the correct syntax for
the select statement?
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
