I agree knowing what the dataset is for might help with the answer. I don't know but I would have thought Units of Measurement are set per Country rather than by City?
Paul On 27 Sep 2012, at 16:44, Jonathan Sundquist <jsundqu...@gmail.com> wrote: > I guess I question what you would like this data set for. Looking at this > from a large scale of the United States I know there are a number of city > names that are duplicated across multiple states. Now I don't know if this > is the same across the rest of the world but you may need to rethink what you > are looking to implement. You may need to set up your relational table from > countries to states/province to cities. > > Also a quick search of Google reveals this page. > http://www.maxmind.com/app/worldcities which can be found on this thread > http://forums.overclockers.com.au/showthread.php?t=899135 . > > On Thu, Sep 27, 2012 at 10:36 AM, Peter Nassef <peter.nas...@gmail.com> wrote: > i need three table .sql content > First: All Countries > Secound: All Cities Related to Countries > Third :Units Measurement > > On Thu, Sep 27, 2012 at 5:08 PM, Maliko V <malikovinc...@gmail.com> wrote: > Can you elaborate what do you need exactly? Us to show you how u create this > schema or model using bake ? > > VM > > Sent from iPhone smartphone > > On 2012-09-27, at 11:02 AM, Peter Nassef <peter.nas...@gmail.com> wrote: > >> Hello cakephp member >> >> i need table content all country and all cities relate to this countries >> and other table content units measurement >> >> >> and Thanks :) >> >> -- >> Like Us on FacekBook https://www.facebook.com/CakePHP >> Find us on Twitter http://twitter.com/CakePHP >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CakePHP" group. >> To post to this group, send email to cake-php@googlegroups.com. >> To unsubscribe from this group, send email to >> cake-php+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/cake-php?hl=en. >> >> > > > -- > Like Us on FacekBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com. > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > > > > > -- > > __________________________________________________________ > Peter Nassef > Mob.:+2 0122 561 6354 > E-mail: peter.nas...@gmail.com > Web Designer, Developer: XHTML, CSS, jQuary, Ajax, JavaScript, PHP& MySql > > > -- > Like Us on FacekBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com. > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > > > > -- > Like Us on FacekBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com. > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > -- Like Us on FacekBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en.