I’d like grab my page uri from a select statement. I believe they are located here:
SELECT site_pages FROM exp_sitesI’m not quite sure how to transform that into something useable.
Suggestions?
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
February 06, 2009 6:41pm
Subscribe [1]#1 / Feb 06, 2009 6:41pm
I’d like grab my page uri from a select statement. I believe they are located here:
SELECT site_pages FROM exp_sitesI’m not quite sure how to transform that into something useable.
Suggestions?
#2 / Feb 06, 2009 6:58pm
Sorry I guess this is more of a mysql question then EE question.
the format is as follows:
a:2:{s:4:"uris";a:133:{i:8;s:19:"/page_uri/";I know the i:num is the id of the article and the “/page_uri/” is exactly that.
guess I’ll just dump this to a spreadsheet and create a new table with that.