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 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 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 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 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.
Re: Hello i need help in database schema ready
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 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 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 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.
Re: Hello i need help in database schema ready
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 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 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.
Re: Hello i need help in database schema ready
I don't know how likely you will find a country and all cities within each specific country. You are more likely to find database schemas out there that give you countries with all related states/provinces within. On Thu, Sep 27, 2012 at 10:08 AM, Maliko V 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 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. > > > -- 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.
Re: Hello i need help in database schema ready
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 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.