Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-11-19 22:32:58
- moslib
- Member
- Registered: 2005-08-11
- Posts: 39
Query database directly (i.e. from without txp)
We have an intranet – and on the opening page would like to include some data from our Textpattern website.
This is currently done using RSS feeds but a much better result for us would be querying the Txp database directly. A contractor will be handling this (as part of a bigger project) – but I would like to give them as much information as possible with regards to the query we want.
So, we would like to replicate whatever queries Txp performs to display latest events (zem_event) and news (article_custom) on the current home page…
Is this possible?
Are you able to intercept or view the mySQL queries as they pass to the database?
Offline
Re: Query database directly (i.e. from without txp)
Set TXP_DEBUG to 1 in textpattern/lib/constants.php and you’ll see all the SQL queries when visiting the page that does these queries.
Offline
#3 2007-11-19 23:31:18
- moslib
- Member
- Registered: 2005-08-11
- Posts: 39
Re: Query database directly (i.e. from without txp)
many thanks
Offline