static and globally filter in sql select statement

relating to implementation of What are best practices for multi-language database design?

how can I declare something similar to static variable t开发者_JAVA技巧hat describes language in that session

now I use a static and globally variable/Session in PHP and concatenation of it to the query string.

---

MySQL supports a local, session and global variables. You want to use session.

To set a session variable, simply:

SET @key = 'value'

All session variables are prefixed with a '@'.

Session variables goes out of scope when the connection is terminated.

In your case, you will still need to AND your queries, like:

SELECT * FROM pages WHERE lang = @lang

You cannot automatically do this.

More info in the documentation.

---

Using an ORM like doctrine would allow you to do things like this using events. See the method preDqlSelect() on this page: http://www.doctrine-project.org/projects/orm/1.2/docs/manual/event-listeners/en