Title: Trying to export database content
Last modified: August 18, 2016

---

# Trying to export database content

 *  [Doodlebee](https://wordpress.org/support/users/doodlebee/)
 * (@doodlebee)
 * [19 years ago](https://wordpress.org/support/topic/trying-to-export-database-content/)
 * I was wondering if I could get a hand with some scripting. I’m using a WordPress
   installation for a sort of online auction. It’s hard to explain, so I won’t bother.
   But what I need to do is export the information from the database to a printable
   list. I’ve managed to do this, however, if there’s more than one comment in a
   post, then it prints the post over and over again, showing each new comment.
 * I know it’s an issue with my “while” statement – I need a loop within a loop,
   but I can’t seem to get it right.
 * What I have is this:
 *     ```
       $default_sort = 'post_title';
       $allowed_order = array ('post_title', 'post_content', 'comment_author', 'comment_content');
       ```
   
 *     ```
       if (!isset ($_GET['order']) ||
           !in_array ($_GET['order'], $allowed_order)) {
           $order = $default_sort;
       } else {
           $order = $_GET['order'];
       }
       ```
   
 *     ```
       /* connect to db */
       mysql_connect ('localhost','name','password');
       mysql_select_db ('db_name');
       ```
   
 *     ```
       /* construct and run our query */
       $query = "SELECT * FROM auction_posts, auction_comments where comment_post_ID = auction_posts.ID ORDER BY $order";
       $result = mysql_query ($query);
       ```
   
 *     ```
       /* make sure data was retrieved */
       $numrows = mysql_num_rows($result);
       if ($numrows == 0) {
          echo "No data to display!";
          exit;
       }
       ```
   
 *     ```
       /* now grab the first row and start the table */
       while ($row = mysql_fetch_assoc($result)) { ?>
       ```
   
 *     ```
       <div id="n<?php echo ($row['ID']); ?>" class="listing">
       <h1><?php echo stripslashes($row['post_title']); ?></h1>
       <?php echo stripslashes($row['post_content']); ?><br />
       ```
   
 *     ```
       <?php $c = $row['comment_content'];
       while ($c > 0) { ?>
       	<?php echo $row['comment_content']; ?> by <?php echo $row['comment_author']; ?><br />
       <?php } ?>
       </div>
       <?php  }?>
       ```
   
 * It’s the “while $c…” stuff that I *know* is wrong. But I can’t seem to figure
   out the proper syntax to see if there’s more than one comment, then loop that
   into lines showing the output of each comment *without* showing the post over
   and over again, each time with a new comment. (I also know the “while $c” part
   is insanely stupid…I’ve tried other, more complicated, variations to no effect.
   That was my “I’m about to quit” effort LOL)
 * Any help would be appreciated.

The topic ‘Trying to export database content’ is closed to new replies.

## Tags

 * [content](https://wordpress.org/support/topic-tag/content/)
 * [custom](https://wordpress.org/support/topic-tag/custom/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [field](https://wordpress.org/support/topic-tag/field/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [scripting](https://wordpress.org/support/topic-tag/scripting/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Doodlebee](https://wordpress.org/support/users/doodlebee/)
 * Last activity: [19 years ago](https://wordpress.org/support/topic/trying-to-export-database-content/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics