This may be simple for most of you MySQL experts out there so a little help would be nice :)
I have an index page that is using a Navigation system based on the ID from a table City: The link then goes a DIR for that City. http://www.theaddress.co.uk/City/ The navigation within this DIR is based on Traders for this City so my problem is? Do I create a table for each City (holding Companies) or is there a way to structure the MySQL DB that can hold all companies in the same table? So when the City is selected all the companies for that City will be listed, baring in mind that all the TraderID's are generic (the same as City) It's only the Company that is specific to City? Help greatly needed and appreciated Andrew --------------------------------------------------------------------- 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
