Hi!
2009/3/18 O. O. <olson_ot(a)yahoo.com>om>:
For the list of Page Titles, I looked into the
Page Table, and simply
got a list of all of the Titles. In SQL I assumed this would be the
result of the Query: “select page_title from wikidb.page;” – The problem
with this is that I am getting a number of Titles that are repeated?? So
I think I am doing something wrong?
page_title does not contains the full title, only its
namespace-relative part. You need to use
select page_namespace, page_title from wikidb.page
Only this whole tuple (page_namespace, page_title) is a unique
identifier of a page (this is true for the whole MediaWiki).
HTH,
-- [[cs:User:Mormegil | Petr Kadlec]]