Re: Hello i need help in database schema ready

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 <jsundquist@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.nassef@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 <malikovincent@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.nassef@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+unsubscribe@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+unsubscribe@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.nassef@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+unsubscribe@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+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.