Title: Post generated from SQL table
Last modified: August 30, 2016

---

# Post generated from SQL table

 *  [volpik](https://wordpress.org/support/users/volpik/)
 * (@volpik)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/post-generated-from-sql-table/)
 * Dear all,
    I am looking for a simple and elegant way to auto generate post from
   a sql table. In short, I have an sql table that include different field, like
   $country, $capital, $population, $www.country.gov, $other_link.com.
 * I would like that the query will generate me a post that will look like this:
 * ———–
    Title: $Country Category: Page+$country — post text —– Capital is $capital,
   population is $population,
 * [wpdatatable id=18 var1=’$country’] (a table generated with wptable plug in)
 * [toggles title=”Government site”] [iframe src=”www.country.gov” width=”60%” height
   =”1300″][/toggles]
 * and so on.
 * Thank you very much for anybody would give me an easy way to implement it, php
   or plugin to use will be very welcome.
    Thanks.

Viewing 1 replies (of 1 total)

 *  [VisualData](https://wordpress.org/support/users/visualdata/)
 * (@visualdata)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/post-generated-from-sql-table/#post-6414044)
 * Hi,
 * You may consider using pods to extend posts and store the post specific data 
   in custom fields. this can easily be done using pods template and post template.
   some of the short code can be stored as post content, or in the post template.
 * If you need to keep the sql table to integrate with other system, you may also
   use pods advanced content types.

Viewing 1 replies (of 1 total)

The topic ‘Post generated from SQL table’ is closed to new replies.

## Tags

 * [auto](https://wordpress.org/support/topic-tag/auto/)
 * [generated](https://wordpress.org/support/topic-tag/generated/)
 * [post](https://wordpress.org/support/topic-tag/post/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [VisualData](https://wordpress.org/support/users/visualdata/)
 * Last activity: [10 years, 7 months ago](https://wordpress.org/support/topic/post-generated-from-sql-table/#post-6414044)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics