Aveligand New member Jun 11, 2007 207 1 0 Nov 14, 2008 #1 I have a dozen or so WP blogs with few hundred posts each that I want to do some linking with. Is there any script, method or plugin that will mass export all the post titles (as anchor text) along with the post links?
I have a dozen or so WP blogs with few hundred posts each that I want to do some linking with. Is there any script, method or plugin that will mass export all the post titles (as anchor text) along with the post links?
$5 Submissions New member Jun 27, 2006 1,957 15 0 Global www.webmasterlabor.com Nov 14, 2008 #2 Sounds like a quick scripting job for cheap developers at scriptlance
Aveligand New member Jun 11, 2007 207 1 0 Nov 14, 2008 #3 Yeah, I'm going down that route if there isn't a free solution available. Intuitively, it wouldn't be likely that I'm the first to need something like this.
Yeah, I'm going down that route if there isn't a free solution available. Intuitively, it wouldn't be likely that I'm the first to need something like this.
S SeanW Janitor Oct 9, 2007 88 4 0 Winterpeg Nov 15, 2008 #4 mysql -B -u root -p -e 'SELECT CONCAT("<a href=\"http://mysite.com/", post_name, "\">", post_title, "</a>") FROM wp_posts WHERE post_status = 1' wordpress Substitute usernames/urls/db/table names as appropriate. Sean
mysql -B -u root -p -e 'SELECT CONCAT("<a href=\"http://mysite.com/", post_name, "\">", post_title, "</a>") FROM wp_posts WHERE post_status = 1' wordpress Substitute usernames/urls/db/table names as appropriate. Sean
bb_wolfe Medicinal KFC Jan 1, 2008 3,118 108 0 Nov 16, 2008 #5 SeanW said: mysql -B -u root -p -e 'SELECT CONCAT("<a href=\"http://mysite.com/", post_name, "\">", post_title, "</a>") FROM wp_posts WHERE post_status = 1' wordpress Substitute usernames/urls/db/table names as appropriate. Sean Click to expand... Holy shit, I never even thought to pull data like that. Nice! Very nice!
SeanW said: mysql -B -u root -p -e 'SELECT CONCAT("<a href=\"http://mysite.com/", post_name, "\">", post_title, "</a>") FROM wp_posts WHERE post_status = 1' wordpress Substitute usernames/urls/db/table names as appropriate. Sean Click to expand... Holy shit, I never even thought to pull data like that. Nice! Very nice!
bb_wolfe Medicinal KFC Jan 1, 2008 3,118 108 0 Nov 16, 2008 #6 EDIT: This is what I had to use instead of post_status = 1. SELECT CONCAT("<a href=\"http://mysite.com/", post_name, "\">", post_title, "</a>") FROM wp_posts WHERE post_status = 'publish'
EDIT: This is what I had to use instead of post_status = 1. SELECT CONCAT("<a href=\"http://mysite.com/", post_name, "\">", post_title, "</a>") FROM wp_posts WHERE post_status = 'publish'
