[Phpug] PHP & DB Design Questions

[AJ McKee]

Hi All,

Hope you are all feeling good and festive. Anyhow, I have a few design 
issues I am hoping your collective knowledge can help me solve.

I am building a app at present that is to serve multiple countries. 
Firstly there is the language issues. I prob won't use a framwork such 
as zend and symfony for this as every bit of performace to be extracted 
will have to be extracted (as in no ORM or anything)(This is not to say 
the aforementioned frameworks are not efficent, just a decision at 
present, maybe you can convince me)

The first issue is the localisation issue. I know I could use gettext 
but this are many issues around its usage, so what are the options for 
decient localisation within PHP? Anyone got ideas.

The second issue I have is in relation to Locations and addresses. 
Without going into too much detail, a person in france has an object and 
want to register it on my site. So they add the location, say something 
like, Rue Someplace, Place Du Here, Paris, 019222, France. Thats grand, 
but now I have a user in Ireland, whom adds an object with the address, 
109 Some Street, Cork, Ireland.

Selecting the country is easy enough to do. However what happens if I 
want to search of objects close to a location, ie, show me all objects 
in Cork, then show me all objects in Place Du Here, in Paris

What is the most effective way of desiging my DB for this type of 
stuff?  Anyone got experience on this stuff. I presume the easist thing 
to so is start my search backwards, Street, District, City Region type. 
but I am wondering if that is effective?

Anyone got advice.

Thanks in advance.
AJ