GoFuckYourself.com - Adult Webmaster Forum - View Single Post

lollipopx · 05-19-2014, 12:04 PM

Ok, here goes another one of my try explain something rambling questions ....
database query to post/page?
ok, so I go to affiliate to hosted galleries tools, select category etc. hit button says show dump, a whole lot o code is generated, click save dump, save as Coma Separated Values or CSV or Tabbed CSV, open said code in excel( match my database perimeters to the excel ones in top cell row), save and upload to my websites database via cpanel/mysql or mysql wizard, open phpmyadmin, database is in left side panel, select it, it opens in the database on right side so I see its there. clicked on just about every button in there I thought maybe relevant to generate or populate to site...
I have read and read and read for days on how to query to post to the point my eyes are killing me. Tried a bunch of different query codes to no avail.

Now funny story. Just the other day I somehow accidently managed to populate over 2000 post without realizing it. Unfortunately they were all empty as the database table wasn't matched up or something, So I had to delete them all. To top it off, I have no damn clue how the hell I did it to repeat it with a proper database table.
I feel like I am missing some minute little detail somewhere to trigger this

I tried posting in text and view in WP post editor the codes I found for query...no luck
Tried to figure how to post shortcodes or the phpgenerated shortcodes ...no luck

I should be able to generate/populate this to selected post or category page from database but HOW?

05-19-2014, 12:04 PM
lollipopx Confirmed User Industry Role: Join Date: Apr 2014 Posts: 171	Database query to post/page Ok, here goes another one of my try explain something rambling questions .... database query to post/page? ok, so I go to affiliate to hosted galleries tools, select category etc. hit button says show dump, a whole lot o code is generated, click save dump, save as Coma Separated Values or CSV or Tabbed CSV, open said code in excel( match my database perimeters to the excel ones in top cell row), save and upload to my websites database via cpanel/mysql or mysql wizard, open phpmyadmin, database is in left side panel, select it, it opens in the database on right side so I see its there. clicked on just about every button in there I thought maybe relevant to generate or populate to site... I have read and read and read for days on how to query to post to the point my eyes are killing me. Tried a bunch of different query codes to no avail. Now funny story. Just the other day I somehow accidently managed to populate over 2000 post without realizing it. Unfortunately they were all empty as the database table wasn't matched up or something, So I had to delete them all. To top it off, I have no damn clue how the hell I did it to repeat it with a proper database table. I feel like I am missing some minute little detail somewhere to trigger this I tried posting in text and view in WP post editor the codes I found for query...no luck Tried to figure how to post shortcodes or the phpgenerated shortcodes ...no luck I should be able to generate/populate this to selected post or category page from database but HOW?